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.
? SQLExec(ln, "Select * From ['Workbook.sheets(1)$']")Is it possible?