| re: trying to append from several different databases
sparks wrote:[color=blue]
> 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[/color]
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
| 
