I import an Excel sheet with the following SQL statement.
SELECT T1.*, 1 AS SheetSource INTO [Excel Import]
FROM (Excel 12.0;HDR=NO;IMEX=1;Database=C:\Access2007\ODBC-Writeback\SFtest.xlsx) [TCM IMPORT - SF$A10:L65536] AS T1;
This works except that it also bings in any 'blank' cells that were in the Sheet. The first try brought in 24 valid records and 200+ blank records.
I created an additional query to delete all of the blanks but it would be nice to take care of it on import.
I have tried to add a Where clause for A10 Is Not Null but get a Syntax error with the cursor positioned on the semi-colon before the HDR paramenter.
Any help is much appreciated.