Importing from Excel to Various Access tables

[lambda75]

Im trying to import multiple columns of data from Excel into multipl
tables in Access. Each table in access is related by some kind of I
(Primary key), so if I import data into one table and then import dat
into another table how would the database know that all the dat
pertains to the same person. Im confused on how to do this if it ca
even be done.

I would really appreciate it
-
lambda7

 

[Tom Wickerath]

Relational databases use primary and foreign keys to relate data between tables. Access
won't automatically know which records go with which. You need to include one or more
fields in the related table, which can be used on a temporary basis, to join to the
primary table in query design view. Then, you run an update query on a foreign key field,
to update its value to the corresponding primary key value. After completing this step,
you can delete the extra field(s) in the related table that were used to define the
temporary join.

Would you like me to send you a well documented example that I created earlier this year
for a former student of mine? If so, send a request to AOS168 at attbi dot
com

Tom
___________________________________________


Im trying to import multiple columns of data from Excel into multiple
tables in Access. Each table in access is related by some kind of ID
(Primary key), so if I import data into one table and then import data
into another table how would the database know that all the data
pertains to the same person. Im confused on how to do this if it can
even be done.

I would really appreciate it.

 

[davant]

Hi,

I am doing the same procedure as you are. May I get a copy of your
solution emailed to me at

(e-mail address removed)

thanks
Deb

 

[Tom Wickerath]

It's on it's way. By the time you read this, you should have received it.

Tom
_________________________________________


Hi,

I am doing the same procedure as you are. May I get a copy of your
solution emailed to me at

<snipped out e-mail address>

thanks
Deb