How to transfer data from one database to another

[alvin8866]

Hi,

I recently designed a new database according an old database in order to replace it. I found that I have trouble tranfering the data from old to new database. I am here to ask for help.

• Only transferring data from one table to another

Database A:

![customer]
to
Database B:

![Client]

• Filed name on both are different

DatabaseA:
Table Customer:
Name,
PhoneNumber,
e-mail.

DatabaseB:
Table Client:
FullName,
HomePhone,
CellPhone,
E-mail.

How can I transfer from "Database A/table customer" to "Database B/table Client"?

 

[pbaldy]

In either db, link to the table in the other, then create an append query that draws from the old table and inserts into the new.

 

[alvin8866]

In either db, link to the table in the other, then create an append query that draws from the old table and inserts into the new.

Thank you, problem solved.

 

[pbaldy]

Happy to help!