Each named range in Excel is a separate table.
You may be able to open a union query against
several 'tables' at the same time: you may be
able to join several 'tables' together (or you
may not...)
Normally when you import, you have a choice of
creating a new table, or appending to an existing
table. Perhaps you need to look at your import
method, and see if you can change it to do append
instead of create.
(david)
