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

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.
>
>
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/02

John Bullock
O C Kay Training


-- No attachments (even text) are allowed --
-- Type: text/plain

Other related posts: