Merge 2 dbs

J

jime

Can I merge 2 dbs in Access 2003? Say one had June data and the other had
exact same data for July.
How would I mere them into one db?
 
J

John Vinson

Can I merge 2 dbs in Access 2003? Say one had June data and the other had
exact same data for July.
How would I mere them into one db?
Click to expand...

Are these two *databases* - .mdb files, with multiple tables, forms,
and reports? Or two *tables*? (Either can be handled but the methods
are different). A UNION query or an APPEND query can be used to
combine the data in two tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format change in merge data - Bold formatting after a comma 0
Merging from an Excel file with graphics 1
Mail Merge skipping records/sending one at a time 0
Auto Populate One Pages from spreadsheet 0
Create a chart from a table in word thats dynamic 0
Auto Merge text from multiple sources 0
How to break up a book's endnotes by chapter in a file containing a whole book? 0
Windows 2016- Unable to do mail merge with my secondary email accounts 1

Top