What is the procedures to import data from excel

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.

--
H. Frank Situmorang
.

Relevant Pages

  • Things to know in import from Excel
    ... database is alwasy a problem. ... Try to import data for tables which become a mother records (primary key) ... Then import the data for table that has child records ...
    (microsoft.public.access.externaldata)
  • Re: Things to know in import from Excel
    ... Without a better idea of how well-normalized the "import data from excel" ... Try to import data for tables which become a mother records (primary ... Then import the data for table that has child records ... Delete the primary key in the child table, ...
    (microsoft.public.access.externaldata)
  • Re: problem using identity column as primary key
    ... >> I am thinking of creating an identity column to use it as primary key ... More and more programmers who have absolutely no database training are ... the gap in the sequence is not filled in and the sequence ... vin CHARNOT NULL REFERENCES Motorpool); ...
    (microsoft.public.sqlserver.programming)
  • Re: Updating the SQL key value
    ... before creating the database, by the time I've come to pick a primary key, ... articles, each of which must be issued under a particular licence (e.g. ... GPL GNU General Public Licence http://www.gnu ... ...
    (comp.lang.php)
  • Re: Concatenate and Null Values -- Features
    ... Tony Toews dislikes cascade deletes as well as cascade updates, ... fence regarding the use of natural versus surrogate (autonumber) keys. ... Database Normalization Tips ... For optimal database design and performance, the primary key of a table ...
    (microsoft.public.access.reports)