Merge 2 dbs

  • Thread starter Thread starter jime
  • Start date Start date
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?
 
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.
 
You must log in or register to reply here.

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

Best solution to merge multiple Outlook contacts easily 2
Is it possible with Access VB to check if any users are logged ontoanother Access DB? 2
Opiions on what is the best method/ format for storing Procedures and Functions developed over time 5
Is it possible to Auto Close an Access db at a scheduled time? 6
Access 2003 Merge dbs 1
Completely hide navigation pane Access 2007 1
2 or more dbs to one 1
Relinking Tables *Problem 2

Back
Top