Click the "Add" button to create a new connection and start the connection wizard. Click the "SQL Native Client" in the list of drivers. The SQL client is included with the Windows 7 operating system.

Click "OK" to return to the Data Connection Wizard, which now lists the database's tables. Click the table whose data you want to export to Excel. Click "Next." ...

Select the Data tab, then from the toolbar select From Other Sources | From Analysis Services. This will start the Data Connection Wizard, which will be used to connect the SQL Server Analysis ...