Merge databases into one

  • Thread starter Thread starter Dan @BCBS
  • Start date Start date
D

Dan @BCBS

I have two large databases. My task is to merge the data so I can report
them thogether as one.
So, in a new database I linked the tables and now I am asking for advise on
the best approach to join two tables. If I create a query and add both
tables, I have no common field between the tables. How do I get all the data
into one query so I can start on the reports?

Thanks
 
I have two large databases. My task is to merge the data so I can report
them thogether as one.
So, in a new database I linked the tables and now I am asking for advise on
the best approach to join two tables. If I create a query and add both
tables, I have no common field between the tables. How do I get all the data
into one query so I can start on the reports?

Thanks
Click to expand...

I'm GUESSING here, since you didn't post any information about the structure
of your databases or the data in them - but to string two tables together into
one taller (more records) recordset, use a UNION query. The two tables do need
to have the same number of fields of matching datatypes, or you must select
only those fields which do match. See the online help for UNION, it's pretty
good; post back with tablenames and brief descriptions if you need more help.
 
Back
Top