Adding & deleting

[david]

Hi
After linking a file from Excel to Access, how do you
delete rows in Excel, without leaving blank records in
Access?

 

[Ann Shaw]

Hi

The only way I can do this is instead of using delete on
the keyboard when you select the row, use Edit Delete and
Shift cells up. That way at least the blank rows will be
at the end all the time.

Probably not what you want but it might get you through
until somebody can do better.

Kind regards

Ann (Ireland)