As far as I know the situation is this:
When you're importing from or linking to data on an Excel worksheet,
(a) If you just specify the name of the sheet, Access attempts to import
the entire UsedRange of the sheet, basically from A1 to the lower-right
cell that defines a rectangle enclosing all the cells that have ever had
data in them. This usually works fine if there's nothing on the
worksheet but the table, but can go wrong if there are totals, other
blocks of data on the sheet - or if some data has been deleted: the
UsedRange is reset when rows and columns are deleted but not when they
are merely cleared.
(b) If you define a named range on the worksheet and import that, Access
imports only the data in the range and ignores the rest of the sheet.
I read in a book that it is not a good practice to
have anything below an external data range in excel. But I have do so
successfully. Could anyone tell me what are the danges of doing this?
I asked a friend and he said that it may be the author's personal
preference. I put totals under the external data ranges and have even
used multiple data ranges in one sheet with rows separating them and
have not had a problem.
