Connected from Excel to Access
Depends houw you are trying to connect... ADO, DAO, ???. For ADO you need.
Microsoft ActiveX Data Objects 2.? Library.
One thing to note is that you may want to select a library somewhere around
2.5 in order to ensure backwards compatability with older version of XL.
--
HTH...
Jim Thomlinson
"Damil4real" wrote:
What other options are needed to be checked in the Microsoft Access
Object Library (Reference - VBA Project) in order to successfully
connect from Excel to Access using a Macro?
I currently have the following options checked:
Visual Basics for Applications
Microsoft Excel 11.0 Object Library
OLE Automation
Microsoft Office 11.0 Oject Library
Microsoft ADO Ext. 2.8 for DDL and Security
MIcrosoft Access 11.0 Object Library
I appreciate your assistance.
Thanks!
|