Text File And ADO

I have a CSV file called "olb.txt" with 5 fields. I created a User ODBC source called "TEST" with the fields defined as:

StartDate
StartTime
AppName
Agent
Duration

While I've successfully used ADO to connect to an Access database, I can't get ADO to connect to this ODBC file and keep getting the error message that the driver is unrecognized.

Can someone tell me how to setup the connection string?

Thanks.

[JHausmann]

Ca you use the Jet "transferSpreadsheet" function to copy the table into Access and manipulate it from there?

[rayed78]

If is of any help, check the preferences.

[Clunietp]

Here is how you can connect to a CSV file without using ODBC or Automation:

'Uses ADO 2.1/5

    Dim cn As ADODB.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