View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
faustino Dina faustino Dina is offline
external usenet poster
 
Posts: 10
Default Modifying an Access record in Excel

You can use ADODB to connect to Access. From Visual Basic window add
Reference to "Microsoft ActiveX Data Objects" and you can use the same
functionality that is present on Visual Basic...

"John Moll" wrote in message
...
I can add records from excel to specific table in Access
DB. I can also extract an individual or all records in
that table in and see them in in Excel.

Whowever I am stuck? How can I modify (and delete) a
specific record in that table (in Access) while in Excel
using VB? Any help would be appreicated.

John