By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,968 Members | 1,215 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,968 IT Pros & Developers. It's quick & easy.

How do I merge 2 databases that have a number of duplicate enteries

P: 1
I have 2 databases that have approximately 9000 records each. The share a number of common fields. I need to move the addresses in the first database into the address field of the corresonding record in the second database. Thanks!
Oct 9 '08 #1
Share this Question
Share on Google+
3 Replies


DonRayner
Expert 100+
P: 489
I have 2 databases that have approximately 9000 records each. The share a number of common fields. I need to move the addresses in the first database into the address field of the corresonding record in the second database. Thanks!
I would do it in vba using dao recordsets.
Oct 11 '08 #2

NeoPa
Expert Mod 15k+
P: 31,709
  1. Do you mean databases or tables?
  2. What determines "corresponding" in your scenario?
Oct 12 '08 #3

NeoPa
Expert Mod 15k+
P: 31,709
This will work much better if you can post the meta-data (info about the layout / structure) of the table in the same way as I use in my example. Click on the Reply button and you will have access to all the codes I've used. PK & FK stand for Primary Key & Foreign Key respectively. Never use TABs in this as the layout gets mucked up. Use spaces and all is fine.
Table Name=[tblStudent]
Expand|Select|Wrap|Line Numbers
  1. Field           Type      IndexInfo
  2. StudentID       AutoNumber    PK
  3. Family          String        FK
  4. Name            String
  5. University      String        FK
  6. Mark            Numeric
  7. LastAttendance  Date/Time
Oct 12 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.