Archive of Mr Excel Message Board

Back to Other Office and Excel archive index
Back to archive home

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.

Re: updating access database table from excel

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.