Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Office 2007 compatibility issues
Message
 
To
03/02/2007 12:52:04
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Third party products
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01191826
Message ID:
01192121
Views:
30
>>Cetin,
>>That works:
>>
>>TEXT TO lcConnString NOSHOW PRETEXT 15
>>     DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);
>>     UID=admin;
>>     FIL=excel 12.0;
>>     DriverId=1046;
>>     DefaultDir=D:\all_zapl_4_9_0;
>>     DBQ=D:\all_zapl_4_9_0\abclist1.xlsx
>>ENDTEXT
>>
>>
>>lnSQL = SQLSTRINGCONNECT(lcConnString)
>>? lnSQL
>>SQLTABLES(lnSQL,[TABLE],[cTest])
>>SELECT cTest
>>BROWSE NORMAL
>>
>>SQLEXEC(lnSQL,[SELECT * FROM _xlnm#_FilterDatabase],[aaaa])
>>SELECT aaaa
>>BROWSE NORMAL
>>
>>
>>SQLDISCONNECT(0)
>>
>>I'll try to do the same with OLEDB
>
>Thank you:)
>Cetin



I don't see any OLEDB providers for Excel 2007. I keep searching...
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform