Thread: Use VBA to update Access table or Query from Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
  
Posts: 535
Default Use VBA to update Access table or Query from Excel
Hi Leungkong,

Can I use VBA to update Access table or Query from Excel?

Of course, using ADO or DAO.
See:

http://www.erlandsendata.no/english/...badacexportado

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

Reply With QuoteReply With Quote