Delete rows from Excel spread sheet While importing to table

G

Guest

I would like to delete the first 12 Rows of the excel spread sheet, that I'm
importing to access table.
 
G

Guest

Two possibilities:
You can use a range for your inport:
DoCmd.TransferSpreadsheet acLink, 8, "PipelineLink", _
varGetFileName, True, "80%!A3:p300"
In the example above, the Sheet's tab name is 80% and I want cells A3:p300

Or,
Import to a temporary table and delete the first 12 rows.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top