>>Hi all.
>>My code SQLSTRINGCONNECT() run good in Windows 7-64bit and Excel 2010-32bit
>>
lcConn = "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};"+;
>> "DriverId=790;Dbq="+m.lcXLS+;
>> ";DefaultDir="+JUSTPATH(m.lcXLS)+";"
>> lnHandle = SQLSTRINGCONNECT(m.lcConn)
>>However, It did not work in Windows 7-64bit and Excel 2010-64bit. lnHandle return =-1
>>
>>I dont know why!!! Please help me.
>>Thanks
>
>What return AERROR()?
>Is instaled Microsoft Excel Driver 32 bit?
>
>MartinaJ
I installed Driver 32 bit from AccessDatabaseEngine.exe. After that I run my code, it is ok. Thanks you very much.
Howerver, I use function import Excel to dbf from menu of VFP. VFP was interupted.