Modifying an Access record in Excel

  • Thread starter Thread starter John Moll
  • Start date Start date
J

John Moll

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
 
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...
 
Back
Top