Import Excel with SQL - again

[tpcervelo]

The following does work however it gets wierd...



SELECT T1.*, 1 AS SheetSource INTO ExcelImport
FROM (Excel 12.0;HDR=NO;IMEX=1;Database=C:\Access2007\ODBC-Writeback\SFtest.xlsx) [TCM IMPORT - SF$A10:L65536] AS T1;

If I change the name of the workbook (such as SFtest.xlsx to SFpipe.xlsx) Access returns an error of "Syntax error on Join Operation" when I try to save the changes.

If I key in or cut/paste the working SQL string to a new query I get the same error.

If i rename the new workbook that I want to test to the name in the working SQL (I haven't changed the SQL qeury or tried to save it...just renamed the xlsx then the import works.

any ideas???

[pkstormy]

I'm not sure about the answer to you question but attached is what I use to do excel imports. It works fairly nicely for xlsx files as well (changing the code for xlsx.)