Import XLS to a table

[stafire_18]

i'm trying to import a xls into a existin table. however even though there is one record in the xls document, it imports about 20 additional blank rows along with that one row containing data. there may be instances where there may be more than 1 row populated with information so setting the range in access will not work for that reason. is there a way to import rows as information is there? and not any blank rows. it's taking up a lot of cells in the table.

 

[Joe4]

There are a few different things you could do. Here are a few.

1. Delete the extra rows in Excel first before importing.

2. Dynamically set your Excel range with a macro.

3. Run a Delete Query in Access to delete lines that have a Null value in some key field.