>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
