About installing an ODBC driver

The ODBC drivers (Open Database Connectivity (ODBC) driver: A program file used to connect to a particular database. Each database program, such as Access or dBASE, or database management system, such as SQL Server, requires a different driver.) provided by Microsoft are installed when you install Microsoft Excel.

If the external database you want to access is not supported by these ODBC drivers, you must obtain and install a Microsoft Office-compatible ODBC driver from a third-party vendor, such as the manufacturer of the database program. Contact the database vendor for installation instructions.

 Note   OLAP (OLAP provider: A set of software that provides access to a particular type of OLAP database. This software can include a data source driver and other client software that is necessary to connect to a database.) databases do not require ODBC drivers. When you install Excel, drivers and support are installed to access databases that were created by using Microsoft SQL Server OLAP Services. To connect to third-party OLAP databases, you must install a data source driver (data source driver: A program file used to connect to a specific database. Each database program or management system requires a different driver.) and client software.

 
 
Applies to:
Excel 2003