ADO is best used to access your data and for data manipulation ie. The ADOX Library gives access to objects, properties and methods to create, modify, and view the database and tables structure.ĪDOX is best used for creating and manipulating database structure and tables, though ADO can also be used for this in limited ways (usually with SQL DDL queries). However, you can create a database table in ADO using SQL. Note that ADO does not by itself support creating databases & tables, which is actually done with ADOX. To use ADOX in your VBA project, you must add a reference to the ADOX Object Library in Excel (your host application) by clicking Tools-References in VBE, and then choose an appropriate version viz. Microsoft Access: Data Access Objects Library (DAO), Connect with Access Databases from Excel using VBA.ĪDOX Table Object & Tables Collection - Properties & MethodsĪDOX Column Object & Columns Collection - Properties & MethodsĬreate Relationship between Tables, using ADOXĪDO Command Object, ADOX View Object, Parameter Queries, Create & Execute Stored Queries / Action Queries with ADOXĪDOX (ADO Extensions for DDL and Security): ADOX refers to 'ActiveX Data Objects Extensions for Data Definition Language and Security', and it is an extension to the ADO library in which additional objects, for creating and modifying database tables, and for security, are exposed. Microsoft Access: ActiveX Data Objects Extensions (ADOX). Import or Export Data from Access to Excel using ADO.Ĥ. Microsoft Access: Use ADO to Execute SQL statements.ģ. Microsoft Access: ActiveX Data Objects Library (ADO).Ģ. Microsoft Access: ActiveX Data Objects (ADO), Connect with Access Databases from Excel using VBA:ġ. Microsoft Access: ActiveX Data Objects (ADO), Connect with Access Databases from Excel using VBA. Microsoft Access: ActiveX Data Objects Extensions (ADOX)