import data with identical table names

[Parasyke]

Thanks in advance to anyone on this... I have a central (Access 2003)
database that I need to import about 10 tables from other databases
(also Access 2003). Unfortunately they all have the table with an
identical name (Orders). Due to the complexity of each database I can't
easily cahnge the name of the ten. Is there a way I can import these
daily and rename them (assuming that is the way?). My goal in the end
is to have a master table (or virtual table through queries) that
aggregates all the day's orders. In all there will be about 200 records
per table. Any clues, strategy? Thanks! Dav

[barry.edmund.wright]

Dav,

There are a number of ways to do this:
The tables in the decentralized DB can be linked to the central DB if
they are visible on a network.

If not directly linkable can the decentralized DBs be copied to a local
drive and then linked.

Linking to a table with the same name automatically changes the name by
adding a 1 or a 2 if three table have the same name.

You may want to use an append query to append all the records to the
Order table in the central DB. Of course all the DBs still must be
visible to one another.

Cheers,
Barry


Parasyke wrote:

Thanks in advance to anyone on this... I have a central (Access 2003)
database that I need to import about 10 tables from other databases
(also Access 2003). Unfortunately they all have the table with an
identical name (Orders). Due to the complexity of each database I can't
easily cahnge the name of the ten. Is there a way I can import these
daily and rename them (assuming that is the way?). My goal in the end
is to have a master table (or virtual table through queries) that
aggregates all the day's orders. In all there will be about 200 records
per table. Any clues, strategy? Thanks! Dav