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
Bookmarks