Need Help!

  • Thread starter Thread starter Diane
  • Start date Start date
D

Diane

OK, I have no more hairs, left, so its time to ask for help.

Seeminly a very simple task, is escaping me.

Here is what I have:

An Excel Table
An Access Data base with a table with the same fields as Excel table

What I want:

To have entries entered on the Excel table, be able to be auto updated to
the corresponding table in the Acess table. I can create a macro in access
to add the records, but every time it runs, it dupes the existing records
from the Excel table, onto the access table. How can I run the macro, or
whatever other way to accomplish this, have ONLY the new or changed records
from the Excel file, update to the Access TAble???

I hvae to believe this is possible, yet, its just not working the way I want
it to.

TIA
Diane
 
Already answered in another newsgroup to which you posted the same question.
(I believe it was microsoft.public.access.gettingstarted)

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")
 
Thanks for your assistance, I should have done that, sorry. I will be more
considerate in the future.

Thanks
Diane
 
Back
Top