Blank rows before data in Excel table

[Guest]

I have a series of EXcel workbooks I receive each month from 3rd parties.
The workbooks have a consistent column layout. There are some blank rows
before the header rows for the columns and then some more blank rows before
the data. This is consistent for all the books.

I set up a table, as a template, in Access with the record layout the
workbooks have. When I try to use Get External Data and Import, the wizard
looks to the first row of the Excel files for the record layout and
formatting. How can I tell the wizard to use my template as the record
layout and just import the data from Excel starting at a row I define?

 

[John Nurick]

Hi Craig,

You can't do this with the import wizard. It's possible, but not exactly
simple, using VBA.

One approach would be to write Access VBA code that launches Excel,
opens the workbook, deletes the blank rows, saves and closes the
workbook and then uses DoCmd.TransferSpreadsheet to import the data.