>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.
See message #
1354708lnResult = SQLEXEC( lnHandle, [SELECT * FROM "Sheet1$"], "myCursor" )
IF lnResult < 0
ENDIF
--sb--