For best results: this site requires that cookies be enabled for proper operation - see Legal Page for more info

Select Any of These

Microsoft® Office 2000 Supported Data Formats and Installed OLE DB Providers

The data sources you need to work with in a typical corporate setting can take a dizzying variety of forms and storage formats, for example:

·         Contact data in a Microsoft Outlook® Address Book or Contacts folder

·         Financial data in a Microsoft Excel workbook

·         A list of products in a Microsoft Word table

·         Customer addresses in a mail merge file

·         Orders data in a Microsoft Access database

·         Sales data in a Microsoft SQL Server™ database

·         Data from other programs, such as dBASE, Paradox, or Lotus 1-2-3

·         Data from a Web page, such as tables or lists

·         Data from Web queries, such as current stock prices

·         Data retrieved through a connection to a database on a mainframe server, or returned from a mainframe program as a text file.

As long as you have Office 2000 applications and the correct drivers, converters, or OLE DB providers installed, you can connect to, open, or import data in all of these formats and many others. By default, Office 2000 installs support for access to the following data formats:

Notes  

·     Your system may have other OLE DB providers installed by other applications or setup programs. To determine what OLE DB providers are installed on your system, open My Computer or Windows Explorer, right-click in a folder, and then click Microsoft Data Link on the New submenu. This will create a new Microsoft Data Link file which is used to save OLE DB connection information to a file. Double-click the file to display the Data Link Properties dialog box, and then click the Provider tab to view the installed OLE DB providers. For information about how to use a Data Link file from ADO, see “Connecting to a Database by Using a Data Link File” in Chapter 14, “Working with the Data Access Components of an Office Solution” in the Microsoft Office 2000/Visual Basic® Programmer’s Guide (Microsoft Press®, 1999).

The Data Link Properties dialog box is also available from within Access 2000 if you open an Access project file (ADP) and then click Connection on the File menu, and also when you are viewing a data access page in Design view if you display the field list, right-click the database name, and then click Connection. However, when this dialog box is viewed within Access 2000, the Provider tab in the Data Link Properties dialog box doesn’t show all installed OLE DB providers. For information about using ADO with OLE DB providers other than those installed by Microsoft Office 2000, see the documentation supplied with the provider or with the application that installed the provider.

·     Your system may have other ODBC drivers installed by other applications or setup programs. To determine what ODBC drivers are installed on your system, double-click ODBC (32bit) (in Windows 95 and 98) or ODBC (in Windows NT®) in the Control Panel, and then click the Drivers tab.

·     By default, the Microsoft Jet 4.0 database engine supports importing, exporting to, and linking to Paradox 3.x, 4.x, and 5.x and dBASE III, III+, IV, and 5 tables (if you link to these tables, the data in them will be read-only). Microsoft Jet 4.0 does not support Paradox 7 and 8 or dBASE 7 tables. For read/write access from Microsoft Jet to all versions of Paradox or dBASE tables, you must also have the Borland Database Engine (BDE) 4.x or later installed on your computer. If you don’t have BDE 4.x or later installed, you can obtain it by installing dBASE 7, Paradox 7 and 8, or Delphi. If you own an older version of the BDE that doesn’t support the Paradox 8 or dBASE 7 file formats, you can upgrade your engine from the Inprise (formerly named Borland) Web site (http://www.inprise.com/).

© 1999 Microsoft Corporation. All rights reserved.

The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, this paper should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.

This document is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS DOCUMENT.

Microsoft, ActiveX, FoxPro, Microsoft Press, MS-DOS, Outlook, Visual Basic, Visual FoxPro, Windows, and Windows NT are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

Questions?

Just Check out some of our sponsors

Shop at BestPrices.Com!

COPYRIGHT 1998 - 2009 All names used are Trademarks of the respective companies

[ Home ] [ Up ]

Send mail to CompanyWebmaster  with questions or comments about this web site.
Copyright © 2009 HALO Computer Technology
Last modified: 03/11/09