Modifying an Access record in Excel
 

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

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