need to merge two databases in access

[Guest]

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

 

[Joseph Meehan]

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

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.

 

[Guest]

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.

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.

 

[Tom Wickerath]

Joseph,

You don't merge databases, so.....

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

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.

 

[Joseph Meehan]

do I open one of the tables first, then do a query. how do I go about
this?

You would start by creating a query based on the table you want to add
to the other table. Just include all the fields in the basic query. Take a
look at it in display mode to make sure you see the records and fields you
want to add to the other database. Then go to design mode and select append
query. You will be asked to pick the table you want to append (add) to.
After that you just run the query using the red "!" symbol.

I am very new to this program.

We all started there. We all found out that Access is not easy to
learn, especially at the beginning. Stick with it, it is worth the effort.

 

[sflz]

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