[pchelpers] Access---need HELP!

Hi all

 

A brother sent me this call for help with importing an Excel spreadsheet into 
an Access2002 database. Below is his message. Could anyone please help? I can't 
get it to work either!

Thanks heaps. Message pasted below:

 

Dear Tonia,

 

Out of desperation, I did not know who else to ask. Perhaps you can answer my 
question:

 

I have a data tracking database designed in Microsoft Access 2002 containing 3 
tables related as seen in the attachment. I also have an Excel spreadsheet with 
all the same columns in a single sheet. How can I import the columns of data 
into the database so that the correct columns are loaded into the appropriate 
tables while maintaining the relationship?

------------------------------------

 

PS I have not included the attachment.

 

Best regards

 

Tonia

 

 




---------------------------------
Get a bigger mailbox -- choose a size that fits your needs.

Other related posts: