You need 64 bit drivers.
>
>In my case Craig's program only worked for lnSQL = SQLSTRINGCONNECT("Driver={Microsoft Excel Driver (*.xls)};" ;
> + "DBQ="+FULLPATH(m.tcXLSFile)+";")
>
>If I try using the second form (commented out), I got this error (I got this error when I opened odbc32 and tried to modify that driver):
>
>So, if I'm using Windows 64 and Office 64, does it mean I can not use the above?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer