| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Export to Access via VBA
You are using the ADO method (ActiveX Data Object). You need to add two references to your VBA from menu tools - Reference 1) Microsoft Access 120.0 Library Object (or latest on your PC) 2) Microsoft ActiveX Data Object 2.8 library (or latest on your PC) -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=199279 http://www.thecodecage.com/forumz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Export to Access via VBA | Excel Programming | |||
| Export from excel to Access | Excel Programming | |||
| Excel export to Access | Excel Programming | |||
| export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
| Export from Access to Excel | Excel Discussion (Misc queries) | |||
![joel[_955_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
