XL2000: How to Use Data Access Objects to Join Tables of Different Formats (213820)
The information in this article applies to:
This article was previously published under Q213820 SUMMARY
Microsoft Excel 2000 provides Data Access Objects (DAO) for Microsoft Visual Basic to allow you to access external databases. Microsoft Query and the Open Database Connectivity (ODBC) add-in (Xlodbc.xla) do not provide a direct means for you to join tables of different database formats. By using DAO, you can join tables of different database formats by attaching the tables to a Jet database. An attached table, or linked table, is a table in another database linked to a Microsoft Jet database. Data for attached tables remains in the external database.
This article provides an example of how to attach tables of different database formats to a Jet database so that the tables may be joined.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbhowto kbinfo kbProgramming KB213820 |
---|
|