Import csv with ODBC

[agibsonsw]

Hello. (Excel 2003)
I'm trying to import a csv file using the ODBC text driver. I got this code (snippet shown) from the internet:
Set cn = New ADODB.Connection
cn.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
"Dbq=" & strFolder & ";" & _
"Extensions=asc,csv,tab,txt;"
I can't open the connection - Microsoft [ODBC Text Driver] (unknown) is not a valid path.

I think it's wrong because the text driver is not an ADO feature, but part of ODBC.
Can someone point me in the right direction? Thanks, Andy.

[HansV]

Try the OLE DB driver:

cn.Open ConnectionString:="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
strFolder & ";Extended Properties=""text;HDR=Yes;FMT=Delimited"";"

[agibsonsw]

Thank you. I've got both versions to work - I had the wrong folder, as I'm using a different computer. Dur!

I apologise; sometimes I struggle for ages, post a question, and then find the answer..

I assume there is no reason, or benefit, to using ODBC for this? Ta, Andy.

[HansV]

You can use OLE DB or ODBC - whichever works for you...