I need to migrate data from one mdb file to another mdb file. The source mdb file has three tables and the target has seven tables. ( The database structure is different). Can anyone please give me a way to automate the data migration process.
Printable View
I need to migrate data from one mdb file to another mdb file. The source mdb file has three tables and the target has seven tables. ( The database structure is different). Can anyone please give me a way to automate the data migration process.
Welcome to the Forums.
This is probably better off in the Databases Forum, but I can still help. Are
the records needing to be imported from three tables into the seven tables?
In other words do you need to split the records into the seven tables?
You could add the three tables as linked tables for the target db and create/run
an append query (insert into sql statement).
If not, then you could just copy/paste the records.
HTH