data migration

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
 
G

GVaught

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.
 

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