Excel 97 was the highest version for this parameter at the MSDN site. I tried 8 and others, but the table never gets records. Could there be something with the XLS file itself that it doesn't like? It's just a simple column and rows of tasks with some bar formatting.

Regards, Renoir

>Renoir,
>
>It works on my PC with Excel 2000 file ("FIL=excel 8.0"). How did you come up with "FIL=excel 97"?
>
>>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
>>

>>