Data sources you can access
Microsoft Office provides drivers that you can use to retrieve data from the following data sources:
- Microsoft SQL Server OLAP Services (OLAP provider)
- Microsoft Access
- dBASE
- Microsoft FoxPro
- Microsoft Excel
- Oracle
- Paradox
- SQL Server
- Text file databases
- Third-party providers
You can use ODBC drivers or data source drivers from other manufacturers to get information from data sources that are not listed here, including other types of OLAP databases. For information about other drivers, see the xlreadme.htm file. For information about installing an ODBC driver or data source driver that is not listed here or in the xlreadme.htm file, check the documentation for the database, or contact your database vendor.
The Data Connection Wizard also provides access to a data source called a data retrieval service. A data retrieval service is a Web service installed on Windows SharePoint Services for connecting to and retrieving data. A data retrieval service can provide access to the following data sources:
- list and document libraries on Windows SharePoint Services
- Microsoft SQL Server
- Microsoft Business Solutions