dbTalk Databases Forums  

need help, tearing hairs out trying to make this work..

comp.database.ms-access comp.database.ms-access


Discuss need help, tearing hairs out trying to make this work.. in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Diane
 
Posts: n/a

Default need help, tearing hairs out trying to make this work.. - 03-07-2004 , 08:01 AM






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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.