>I'm trying to extract data form Excel via ODBC.
>I can connect like that:
>

>lcStringaConn = "Driver={Microsoft Excel Driver (*.xls)};" ;
>           		+ "DriverId=790;" ;
>           		+ "Dbq=E:\myDir\myFile.xls;" ;
>           		+ "DefaultDir=E:\myDir"
>           	
>ln = SQLStringConnect(lcStringaConn)
>

>
>I' can get data with:
>

>? SQLExec(ln, "Select * From ['Sheet1$']")
>

>
>but the first sheet is often renamed so I've the need to extract data from the first sheet without knowing the name of the sheet.
>Something like:
>

>? SQLExec(ln, "Select * From ['Workbook.sheets(1)$']")
>

>
>Is it possible?
>TIA
>Bruno

You could use SQLTABLES to get the list of used sheets and then decide from where you want to get data.