Microsoft Office provides drivers that you can use to retrieve data from many data sources, including Microsoft SQL Server, SQL Server OLAP Services, and Microsoft Access. You can use ODBC drivers or OLE DB providers from other manufacturers to get information from sources other than Microsoft data sources, including other types of OLAP databases. For information about other drivers, see the xlread10.txt file. For information about installing an ODBC driver or OLE DB provider that is not listed here or in the xlread10.txt file, check the documentation for the database, or contact your database vendor.
If you choose the Other/Advanced data source option, you can view a list of available OLE DB providers in the Data Link Properties dialog box. For more information, click Help in the Data Link Properties dialog box.