thanks
"Rob Bovey" wrote in message
...
Hi Andre,
These are just two minor variations on exactly the same connection
string. There is only one ODBC driver for Excel.
--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/
* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
"andre" wrote in message
...
Hi,
I found two odbc excel drivers:
1)
objconn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
"FIL=excel 8.0;" & _
"DefaultDir=d:\;" & _
"MaxBufferSize=2048;" & _
"PageTimeout=5;" & _
"DBQ=C:\excel.xls;ReadOnly=0;"
2) objconn.open("DBQ=C:\excel.xls;DefaultDir=C:\l;Dri ver={Microsoft
Excel
Driver (*.xls)};ReadOnly=0;")
Are there differences? Which one is the best?
Thanks
Andre