importing from excel

[chriswrcg]

I am following all the steps to import a spreadsheet into the data base and am selecting to import as a new table. Everything is coming in fine except that access keeps adding a bunch of blank record to the end of the data. In my spreadsheet I have 20 records but after I import it I have somewhere like 75. How do I get it to only import the data and not create blank records?

[Gicu]

You need to reset the "Used Range" in your Excel file by selecting those empty records and deleting them. As an alternative simply add a delete query in your Access import script to delete all the empty records after import.

Cheers,