Things to know in import from Excel

[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.

 

[Jeff Boyce]

Frank

Without a better idea of how well-normalized the "import data from excel"
might be, here's a generic approach:

1. Import the data into (temporary) tables in Access.
2. Create your (permanent) well-normalized table structure in Access.
3. Create queries that append data from your temporary table(s) into your
permanent table(s).

Regards

Jeff Boyce
Microsoft Office/Access MVP