The information in this article applies to:
SYMPTOMSIn Microsoft Excel, when you use the OpenDatabase method or the Connect property, if you use "Excel 7.0;" for the database type, you may receive the following error message: Note that the Microsoft Excel 7.0 Help topic for the Connect property indicates that "Excel 7.0;" is a valid database type specifier. This information is incorrect. WORKAROUNDTo use data from a Microsoft Excel 7.0 workbook with Data Access Objects (DAO), use "Excel 5.0;" for the database type. For example:
You can use "Excel 5.0;" for the database type for both Microsoft Excel 5.0
and 7.0 files because these versions share the same file format. Also, DAO
uses the same installable ISAM to access both versions of Microsoft Excel.
To use data from a Microsoft Excel 97 workbook with DAO, use "Excel 97;" for the database type. MORE INFORMATION
In Microsoft Excel, you can use DAO in a macro to access external data.
When you use the OpenDatabase method or the Connect property, you provide a
string that specifies information about the database.
connectand then double-click the selected text to go to the "Connect Property" topic. In the "Connect Property" topic, in the table that shows possible database types and their corresponding database specifiers and paths for the Connect property setting, note that the table includes "Excel 7.0;" in the Specifier column of the table. This information is incorrect. Additional query words: 8.00 97 XL97
Keywords : kberrmsg kbdta xldao KbVBA xlwin |
Last Reviewed: November 9, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |