adding two database file

G

gokul

Im having two database file for eg. emp1.mdb & emp2.mdb having same fields.I
want to add emp1 datas to emp2 database file.Is it possible
 
G

Guest

hi,
yes, it is.
in emp2.mdb select the table then go
file>saveas/export>brouse to emp1.mdb>click ok
this will put the table from emp2 into emp1.
you can then write an append query to append the data from
one table to the other.
 

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

Top