Modifying an Access record in Excel

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
 
F

faustino Dina

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Autonumber field in Excel that behaves the same as Access 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Merging from an Excel file with graphics 1
Integrating information from Word to Excel (not mail merge) 1
Extract embedded excel file from word document 0
How do I clear a form? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top