Delete rows from Excel spread sheet While importing to table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to delete the first 12 Rows of the excel spread sheet, that I'm
importing to access table.
 
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.
 
Back
Top