Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Office 2007 compatibility issues
Message
From
03/02/2007 15:28:56
 
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:
01192130
Views:
36
>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



That does not get me the data but seems to return the schema!?

Peter
Peter Cortiel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform