mdb to mdb

bhusiva

New member
Local time
Today, 13:32
Joined
Dec 5, 2007
Messages
3
i have an mdb with lot of tables in it. But now since the old mdb is not so flexible the way user wanted, the requirement is creating a new mdb with different tables some of them matches the way the old table but some it is combination of fields from more than table in old mdb.


For example old.mdb table name: associate Fields : first name, last name. personid
table name: Network Fields : network id, person id

New mdb
table name associate: firstname, lastname, personid, networkid
How do i do it?
 
With lots of careful planning! An approach would be to create queries in your existing db and export to Excel, create new tables in new db and import data.

BUT - take care id numbers will still match up
 

Users who are viewing this thread

Back
Top Bottom