MrExcel Publishing
Your One Stop for Excel Tips & Solutions

updating access database table from excel


Posted by SasHa m. on December 16, 1999 4:33 AM

How can i update access table after i imported it into excel from a query? Is there a way i can have this done automaticaly? (Instead of copying the data, deleting old data in access, and then pasting the updated data in the table) Somebody please help.


Posted by Chris on December 16, 1999 9:19 AM


It can be done through DAO or ADO. This is a relatively complicated subject that is likely beyond the scope of this forum. You will find some examples of DAO and ADO here:

http://w1.2735.telia.com/~u273500023/english/index.htm

It will likely make your head hurt as it does mine.

HTH,
Chris