[pchelpers] Re: Access---need HELP!


Hi John B
 
Thanks so much. I've forwarded your email to the brother. 
 
Best regards
 
Tonia
 
 John Bullock wrote:Just did that and it worked fine. So check that the table 
that you are 
importing in to is closed.
It used not to work in previous Access versions if some of the Add Ins for 
importing were not loaded. I always do a full install, do absolutely 
everything you can do before trying these "fancy" bits.

If it's working correctly the wizard pops up and asks which columns match 
what and if the excel book has more than one sheet which sheet you want and 
so on.

Check your addin manager and good luck

Cheers
John B
At 20:19 25/09/02 +0100, you wrote:


>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: