migration of data in old table to new table

[Guest]

Hi all

I currently have 2 database. 1 old one and 1 new now. Due to requirement changes, the tables previously in the old database have been modified. Some fields removed and some new fields added. For example, one of the table residing in both the old and new database is PD. Below are the list of fields in Old PD and New PD

OLD tbl Name: PD NEW tbl Name: personal_Details
ID >> EmpID
FirstName FirstName
MiddleName MiddleName
LastName LastName
Nationality Nationality
Remarks Remarks
Active/Not Active Active/Not Active
Date of Birth Date of Birth
Email Email
Photo Photo
Title >> jobTitle
Sex Sex
Area/Region Area/Region
Country Countr
Marital Status Marital Status
Family Size Family Size
Actual Start Date Actual Start Date
Date Joined Coy (new field
Others (new field
State (new field
Location (removed from table

Is there any tool in MS Access that allows me to migrate the data from the old table to the new table
Thanks in advance

yan

 

[Steve Schapel]

Yann,

In the case of the example you have given, an Append Query will be
applicable. That is, assuming both tables contain data. If the old
table contains the data, and the new table does not, then you don't
really need a new table at all... the changes such as changing field
names and adding new fields can simply bve done on the old table.

 

[Guest]

Thanks for replies, Steve and David

David
Must the 2 tables be in the same Database? I currently have 2 different database, so I am not sure if it'll work as you suggested

Thanks in advanc
yann