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" )