Other Database Sources

Apart from Microsoft Access, the Get Data command on the Data tab also enables you to import data from a variety of database sources including:

• From SQL Server Database : To import data or create a connection to an SQL Server database.

• From Analysis Services : To import data from an SQL Server Analysis cube.

• From SQL Server Analysis Services Database (Import) : This is to import data from an SQL server database with the option to use an MDX or DAX query.