Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLSTRINGCONNECT() fails in Windows 7 64bit and Excel 6
Message
From
30/11/2012 21:43:28
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01558470
Message ID:
01558520
Views:
51
>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform