Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLSTRINGCONNECT() fails in Windows 7 64bit and Excel 6
Message
De
30/11/2012 21:43:28
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Divers
Thread ID:
01558470
Message ID:
01558520
Vues:
50
>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform