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 |
Share This Content! |