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.