Combining tables

[Peter]

Lets say I have several databases with tables in them. I
created another database with a table to hold all the
information from the other tables in order to streamline.
How can I bring the information from the other tables into
one specific table?

Thanks

Peter

 

[Duane Hookom]

You can link the tables from all the other databases into one. Then use
append queries to append all the records to a single table.

 

[Guest]

Thank you. It worked great.

Pete

-----Original Message-----
You can link the tables from all the other databases into one. Then use
append queries to append all the records to a single table.

--
Duane Hookom
MS Access MVP





.