Step | Action | Details |
1 | Launch Excel 2010 | ![]() |
2 | On the Data tab, in the Get External Data group, click From Other Sources, and then click From Data Connection Wizard. | ![]() |
3 | Select Microsoft SQL Server, and then click Next. | ![]() |
4 | Enter the name of the server (by default, it is the network name of the computer) and a user account that has a valid login and database permissions.
Server Name: MPNTPRJ10G Select Use Windows Authentication radio button Click Next. |
![]() |
5 | Select a database ProjectServer_PS_Reporting, and then highlight the table you want to connect to (MPN_DepartmentKPIValues in our example)
You could also choose to write a sql statement that draws data from multiple tables or views and use that instead. Click Next. |
![]() |
6 | Enter a name for the file, and then click Finish.
Use the given name |