>Thanks. I have looked at the old thread and I am typing everything correct. I can open the file with Excel 2007 but still get the error "Sheet1$" is an invalid object.
>
>lcConn = "Driver= {Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; DBQ=C:\_v7data\ImportTest\export\excel2007export.xlsx"
>
>lnHandle = SQLSTRINGCONNECT( lcConn )
>lcCmd = "Select * FROM [Sheet1$] "
>
>lnSuccess = SQLEXEC( lnHandle, lcCmd, "mycursor" )

Did you try double quotes instead of [] as was in that message?