F
Frank Situmorang
Hello,
Trying to import data from excel that originally exported from other
database is alwasy a problem. In this case when we want to APPEND the data
into our current database
What is the best way/ steps to follow. When I made a trial and error, it
seems the following we should be ( pls correct me when I am wrong):
1. Try to import data for tables which become a mother records ( primary key)
2. Then import the data for table that has child records ( foreign key)
3. Delete the primary key in the child table, let computer adds it when you
process import.
Thanks for any idea provided.
Trying to import data from excel that originally exported from other
database is alwasy a problem. In this case when we want to APPEND the data
into our current database
What is the best way/ steps to follow. When I made a trial and error, it
seems the following we should be ( pls correct me when I am wrong):
1. Try to import data for tables which become a mother records ( primary key)
2. Then import the data for table that has child records ( foreign key)
3. Delete the primary key in the child table, let computer adds it when you
process import.
Thanks for any idea provided.