Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access External data > What is the pro...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 10898 of 11313
Post > Topic >>

What is the procedures to im****t data from excel

by =?Utf-8?B?RnJhbmsgU2l0dW1vcmFuZw==?= <hfsitumo2001@[EMAIL PROTECTED] > Aug 6, 2008 at 07:55 PM

Hello,

Trying to im****t data from excel that originally ex****ted 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 im****t data for tables which become a mother records ( primary
key)
2. Then im****t 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 im****t.

Thanks for any idea provided.

-- 
H. Frank Situmorang
 




 1 Posts in Topic:
What is the procedures to import data from excel
=?Utf-8?B?RnJhbmsgU2l0dW1  2008-08-06 19:55:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 19:47:21 CST 2008.