Two Databases into one

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Marc Ortiz
    New Member
    • Sep 2006
    • 2

    #1

    Two Databases into one

    Hello,

    I am a little new to access and I have a problem. I have two databases one is a complete database and the other is a supplemental database that has similiar and unique fields. I need to combined these together and match based on specific fields. Then export and create one large database for all the records that matched up. Would anyone please help me out and remember I'm new to this and step by step instructions would really be appreciated.

    Thank You,
    Marc
  • PEB
    Recognized Expert Top Contributor
    • Aug 2006
    • 1418

    #2
    Hi man! Welcome!

    So you need to link the tables from the suplementary database to the main database!

    It's everything!

    How to do?

    From your main database go to file Get External data -> Link tables

    and choose your supplementary db, choose also that your db is access db!

    :)

    Comment

    Working...