Hi!
I would like to connect to a CSV file,
To me, the connection is right, however i get the following message
'Data source name not found and no default driver specified'
What is wrong with this connection?
Thanks for your help!!!

set objExcel = server.createobject("adodb.Connection")



strConn ="DRIVER=Microsoft Text Driver (*.txt; *.csv);" &_
"UID=admin;UserCommitSync=Yes;Threads=3;SafeTransa ctions=0;" &_
"PageTimeout=5;MaxScanRows=8;MaxBufferSize=2048;FI L=text;" &_
"DriverId=27;DefaultDir=C:\INETPUB\WWWROOT\TESTCOD EGENERATOR\IMPORTEXCEL\UPLOAD;"&_
"DBQ=C:\Inetpub\wwwroot\TestCodeGenerator\importex cel\upload\ALCONTCT.csv;"

objExcel.Open strConn