| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I view a specific record in Access from an Excel link | Excel Discussion (Misc queries) | |||
| How do I Consolidate an EXCEL Report into a record for ACCESS impo | Excel Discussion (Misc queries) | |||
| Obtaining a single Access record from Excel input | Links and Linking in Excel | |||
| record an excel macro, save on network so that everyone can access | Excel Discussion (Misc queries) | |||
| Export Access Record to Specific Cells in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
