Updating a Database using c.s.v files

[Clunietp]

here is some VB/ADO code I have previously written to connect to a CSV text file. This should get you started with what you need to do (assuming you're familiar with databases and VB vs. VBScript)

'Uses ADO 2.1+

    Dim cn As Connection
    Dim rs As Recordset
    
    Set cn = New Connection
    Set rs = New Recordset
    
    'open connection to folder that contains the CSV file
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\;Extended Properties=Text;"
    
    'open the file
    rs.Open "select * from test.csv", cn
    
    'we have data
    MsgBox rs.Fields(1).Value