>I have a valid connection handle to a Excel 2007 file. I execute the following: SQLEXEC( lnHandle, "SELECT * FROM [Sheet1$]", "myCursor" ) and get no return. I run AERROR() and it tells me that, " "Sheet1$" is not a valid name. Make sure it does not contain invalid characters or punctuations and that it it is not too long".
>
>
>Is my string wrong? I had this working at one time.
Did you check SQLTables() and sure that Sheet1 exists as a table? Check if this helps:
http://www.foxite.com/archives/vista-excel-compatibility-w-worksheets-0000153776.htmCetin