>>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