Connecting to CSV file via ADODB connection throwing error : no default driver name

[jaryszek]

Hi Guys,

i want to connect to CSV file from Excel using Adodb connection:

Please Login or Register  to view this content.

where myPath is a folder path.

I am using Excel:
Screenshot_24.png

Error is:
Screenshot_23.png

Error text is :

[Microsoft][ODBC Manager] Data source name not found and no default driver specified

and my set up in odbc drivers (64 bit) is:
Screenshot_22.png

Anyone can help?
What should i do?

Best,
Jacek

[jindon]

See

https://www.connectionstrings.com/textfile/

[jaryszek]

Thank you jindon,

i figured it out:

Please Login or Register  to view this content.

use this code for 64 bit.

Best,
Jacek