By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

import data with identical table names

P: n/a
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

Dec 12 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Dec 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.