Opening Other Database File Formats by Using the Microsoft Jet 4.0 OLE DB Provider
The Microsoft Jet database engine can be used to access data in other database file formats, data in Excel and Lotus spreadsheets, and textual data stored in tabular format through installable ISAM drivers. In order to open external formats supported by the Jet database engine by using ADO and the Microsoft Jet 4.0 OLE DB Provider, you specify the database type by using the Extended Properties property of the Connection object. The following procedure shows how to open a Microsoft Excel 97 or 2000 spreadsheet.
The OpenExcelDatabase procedure can be found in the OpenDatabase module of the DataAccess.mdb sample file, which is available in the ODETools\V9\Samples\OPG\Samples\CH14 subfolder on the Office 2000 Developer CD-ROM.
For a list of Extended Properties property settings for all database types supported by the Microsoft Jet 4.0 database engine, see "Extended Properties Property Settings" in ADOProperties.doc in the ODETools\V9\Samples\OPG\Appendixes folder on the Office 2000 Developer CD-ROM.
Note that if you are migrating from DAO 3.5 or earlier with the FoxPro ISAM to ADO with the Microsoft Jet Provider, you will need to use Microsoft Visual FoxPro® ODBC Driver because Microsoft Jet 4.0 does not support the FoxPro ISAM.
The following table lists the Extended Properties property values to use for the data sources supported by the Jet database engine.
Table 14. Extended Properties property values
1 The Excel 5.0 source database type string is used to specify both Microsoft Excel 5.0 and 7.0 workbooks.
2 The Excel 8.0 source database type string is used to specify both Microsoft Excel 8.0 and 9.0 workbooks.
3 The Exchange 4.0 source database type string is used to specify Microsoft Exchange 4.0, 5.0, and Outlook folders and address books.
Send mail to firstname.lastname@example.org
with questions or comments about this web site.|
Copyright © 1998-2003 XOCOMP, llc
Last modified: 07/01/2002