By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,601 Members | 1,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,601 IT Pros & Developers. It's quick & easy.

update Access table by VBA in Excel

P: n/a
How can I update an Access table based on a sheet in Excel by VBA in excel.
Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"john_liu" <jo******@charter.net> wrote in message
news:F1*****************@fe06.lga...
How can I update an Access table
based on a sheet in Excel by VBA
in excel.


You can write Visual Basic for Applications (VBA) code in Excel, and use
either Data Access Objects (DAO) or ActiveX Data Objecst (ADO) library
support to write to the Jet database. You may need to set the library
reference.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.