I've found some very useful vba code that will append an access table with excel range data. Code uses ADO and makes use of the AddNew property of the recordset.
Is it possible to enhance the code to not only append new data but update existing data if the records already exists in the table??
Please Login or Register to view this content.
Re: Update & Append Access Table Using Excel Macro - ADO
U gor any answer for this as I also stuck on same thing. let me know....
Vish
Last edited by romperstomper; 08-19-2010 at 04:50 AM. Reason: remove quote
vish2025,
Since you have already posted your own question about this and there clearly aren't any responses here, please don't just add your question to someone else's. It doesn't help and actually makes it look like the OP has had a reply. Also, don't quote entire posts in your reply - it clutters the board.
Thanks.
Remember what the dormouse said
Feed your head
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks