how to write VBA code retrieve data from Excel to Access

[Paul]

I have an excel table and access database. Everytime I get errors when I try
to import the excel table into the Access. So I decided to use VBA to do it,
but I don't know how to write the codes in the Access file to control the
excel data. For example, how can I let my Access VBA code read data from the
other excel file?

 

[Douglas J. Steele]

Already answered in another newsgroup to which you posted the same question
(sorry, I don't remember which one)

 

[Douglas J. Steele]

Already answered in another newsgroup to which you posted the same question
(sorry, I don't remember which one).

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)

I see you're using Outlook Express. Click the "Newsgroups:" label to the
left of the box containing the name of the current newsgroup. That will open
a dialog that will let you add additional newsgroups to your post. Note that
it's generally consider to be A Bad Thing to cross-post to more than about 2
or 3 newsgroups. (In fact, at
http://www.microsoft.com/presspass/features/2001/Mar01/Mar27pmvp.asp
Microsoft suggests that "One group will suffice")

 

[Paul]

Doug Steele,
Thank you for your advice and you are right, I am a novice here. Don't
know too much things about Newsgroup. But I can see that here got many warm
hearted expert like you. Thank you very much. I will keep up.