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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
