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

trying to append from several different databases

P: n/a
I have 4 databases that are all the same thing.
These are from different sites but we made sure that
no 2 databases are using the same id's and autoid's so
all the tables are unique in their data and linking.

but now they want to merge/append all of them into 1 database.
there are 14 tables in each one that have to me consolidated into one.

Is there a nice easy way to do this?
I know I could manually append each table from each database one at
a time but I was thinking that I could link to the tables, append and then move
to the next one.

can someone give me a good idea of where to start and how to approach this?

thanks big time for any and all help

Jerry
Mar 9 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Br
sparks wrote:
I have 4 databases that are all the same thing.
These are from different sites but we made sure that
no 2 databases are using the same id's and autoid's so
all the tables are unique in their data and linking.

but now they want to merge/append all of them into 1 database.
there are 14 tables in each one that have to me consolidated into one.

Is there a nice easy way to do this?
I know I could manually append each table from each database one at
a time but I was thinking that I could link to the tables, append and
then move to the next one.

can someone give me a good idea of where to start and how to approach
this?

thanks big time for any and all help

Jerry


I think I'd just create some queries, import one lot, run the queries,
delete the imported tables, import the next lot and so on.... I'm sure there
are a number of variations to this.
--
regards,

Br@dley
Mar 9 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.