Import Spreadsheet into Access

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

Is there any way to prevent the empty rows below my data in excel from being
imported into my access table. I generally have to go into my access table
and manually delete all the empty rows usually this is around 60,000 rows.
Any help would be appreciated.

Thanks,

Jon
 
Rather than importing the file, provide the data you want to import with a
Range Name and then import the range rather than the file.

Good Luck.
 

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

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Subscript out of range when importing into access 2010 from excel 0
Excel Access - importing an excel spreadsheet 0
Importing Text Files Into Access 1
How to export table from outlook into ms access table? 0
need to input alternate blank rows in spreadsheet 5
Hpw do I delete multiple empty rows found between filled rows? 1
Counting NON-Blank fields 2

Back
Top