Hi Renoir,

Today I got a chance to take a closer look at this problem an found out that SQLTABLES return list of the sheets in Excel file with following call.

nTables = SQLTABLES(lnConnHand, ['TABLE','SYSTEM TABLE'], 'tExcelFile')

HTH

>Sergey,
>
>I get a valid handle, but the SQLTABLES creates tExcelFile with no records. Is there something else I need to do to tell it to get the Excel file as data?
>
>Regard, Renoir
>
>

>lcConnStr = ;
>"DRIVER={Microsoft Excel Driver (*.xls)};" + ;
>"FIL=Excel 97;" + ;
>"DefaultDir=D:\Tools\Tasks;" + ;
>"DBQ=D:\Tools\Tasks\TaskList.xls"
>lnConnHand = SQLSTRINGCONNECT(lcConnStr)
>
>IF lnConnHand > 0
>	STORE SQLTABLES(lnConnHand, 'TABLE', 'tExcelFile') TO nTables
>	IF nTables > 0
>	   SELECT tExcelFile
>	   lcSheet=ALLTRIM(tExcelFile.Table_Name)
>		lnSqlRes = SQLEXEC(lnConnHand, [SELECT * FROM "]+lcSheet+["],'tImport')
>	ENDIF
>	ln=SQLDISCONNECT(lnConnHand)
>	USE IN tExcelFile
>	USE IN tImport
>ENDIF
>