blank rows in linked table

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

Guest

Hi

this is not exactly a problem. but i m just curious to
know wht's the matter here.

I have an linked excel table in access which is that
linked to a form to print the records. the excel file will
be updated daily (i copy 2 of the columns from another
software and overwriting the current ones. the third
column contains a vlookup formula). so the size will not
be constant. if the previous list was bigger than the
current one, i have to delete the rows which were occupied
in previous list but empty in current one. Now, if i
delete the rows using keyboard access shows empty rows in
the table. to get rid of this i have to go to Edit/Delete.
From what i understand "delete" button on keyboard should
clear the contents the contents but apparently it doesnt
seems to be doing that??

any ideas?

thanks
 
Excel maintains a UsedRange property for each worksheet, which is
(basically) the rectangle from A1 to the bottom right cell that's ever
been used and hasn't been deleted since. (The delete key in Excel is
mapped to Edit|Clear|Contents, which is a totally different operation
from Edit|Delete).

When importing or linking from Excel, if you just tell it which
worksheet to use Access will try to import or link the entire UsedRange.
So you either need to delete (as opposed to clear) surplus rows before
you import, or else define and maintain a named range in Excel that
includes just the cells you want to import, and then import the named
range instead of the worksheet.
 
Back
Top