need to merge two databases in access

  • Thread starter BronzedandBlond
  • Start date
B

BronzedandBlond

does anyone know how to merge two databases in microsoft access 2003? I have
the two databases linked and on the same page, but, I don't know how to merge
them. I tried importing one into the other and that didn't work. help!!!!you
can email me at: bronzedandblond(removethis)@hotmail.com or just post an
answer. thanx
 
B

BronzedandBlond

Joseph Meehan said:
You don't merge databases, so I will assume you want to combine tables,
either within the same database or from two different databases.

You use an append query and you will need to make sure both tables have
the same field definitions. Just follow the prompts in the wizard.
Click to expand...

do I open one of the tables first, then do a query. how do I go about this?
I am very new to this program. I don't think the query wizard said merge
query. do you know which one I use? thanx, for the help.
 
T

Tom Wickerath

Joseph,
You don't merge databases, so.....
Click to expand...

Sure you do, if you need to combine two similar databases into one database. Danny J.
Lesandrini, a Microsoft Certified Professional and published author, has an article posted on his
web site with the following title:

"Merge Two Identical Access Databases Into One"

It is the last download located on this page:
http://www.amazecreations.com/datafast/daaug.aspx

Also, see:
http://www.merriamwebster.com/cgi-bin/dictionary?book=Dictionary&va=merge


Tom
__________________________________

does anyone know how to merge two databases in microsoft access 2003?
I have the two databases linked and on the same page, but, I don't
know how to merge them. I tried importing one into the other and that
didn't work. help!!!!you can email me at:
bronzedandblond(removethis)@hotmail.com or just post an answer. thanx
Click to expand...

You don't merge databases, so I will assume you want to combine tables,
either within the same database or from two different databases.

You use an append query and you will need to make sure both tables have
the same field definitions. Just follow the prompts in the wizard.
 
S

sflz

BronzedandBlond said:
does anyone know how to merge two databases in microsoft access 2003? I have
the two databases linked and on the same page, but, I don't know how to merge
them. I tried importing one into the other and that didn't work. help!!!!you
can email me at: bronzedandblond(removethis)@hotmail.com or just post an
answer. thanx
Click to expand...
 
Top