data migration

  • Thread starter Thread starter brian
  • Start date Start date
B

brian

Hey all -

Ive got what seems to be a pretty simple task:

Need to migrate data from an old database to a new one. Unfortunately, the
naming conventions in the new one are totally different. The most
simplified situation is as follows, please advise to the best way to
automate the migration:

OLD_TABLE
LastName
FirstName

NEW_TABLE
last_name
first_name

THanks in advance for any suggestions.
Brian
 
You should be able to link the old databases into the new database and then
create an Append query to add the old data to the new fields. You will have
to manually set the fields in the query as the naming difference. This of
course is assuming the old database is in a format that Access recognizes or
is an older version of the database.
 
Back
Top