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.