Hi Guys,

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

Sub test

Set objConn = CreateObject("ADODB.Connection")
    
objConn.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
              "Dbq=" & myPath & ";Extensions=asc,csv,tab,txt;"

end sub
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