Difference between revisions of "Exporting From DB to Excel"
From SDU
m |
m |
||
| Line 1: | Line 1: | ||
| + | __NOTOC__ | ||
| + | <div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br> | ||
| + | To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div> | ||
| + | |||
| + | == Overview == | ||
This article contains the procedures for importing data from the Service Desk to an MS Excel file. Please note that these procedures extract data directly from the MDB (Service Desk database) via simple query through a data source. | This article contains the procedures for importing data from the Service Desk to an MS Excel file. Please note that these procedures extract data directly from the MDB (Service Desk database) via simple query through a data source. | ||
| − | |||
'''WARNING''': Continuous running of such queries that run long or return too much data can cause performance issues to users logged on and working on the application. | '''WARNING''': Continuous running of such queries that run long or return too much data can cause performance issues to users logged on and working on the application. | ||
| + | |||
| + | == Procedures == | ||
#Open a new clean Excel file<br> | #Open a new clean Excel file<br> | ||
#Go to Data -> Import External Data -> New Database Query<br> | #Go to Data -> Import External Data -> New Database Query<br> | ||
#Select the fields you need and run the query (''link tables if you have to'')<br> | #Select the fields you need and run the query (''link tables if you have to'')<br> | ||
#Export to Excel and save the file (''If you already have the query somewhere, just follow the steps and instead of selecting the fields, you simply paste your query and run it then save the results to an excel spreadsheet'') | #Export to Excel and save the file (''If you already have the query somewhere, just follow the steps and instead of selecting the fields, you simply paste your query and run it then save the results to an excel spreadsheet'') | ||
| − | |||
| − | |||
Next time you want to run the same query to get the updated data, you simply do the following: | Next time you want to run the same query to get the updated data, you simply do the following: | ||
#Open the Excel file from the previous steps<br> | #Open the Excel file from the previous steps<br> | ||
#Go to Data -> Refresh Data (''This will run the query and return the new data to the spreadsheet'') | #Go to Data -> Refresh Data (''This will run the query and return the new data to the spreadsheet'') | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 21:50, 25 July 2008
To make corrections or additions to this article, select the edit tab above.
To discuss or ask questions about this article, select the discussion tab above.
To discuss or ask questions about this article, select the discussion tab above.
Overview
This article contains the procedures for importing data from the Service Desk to an MS Excel file. Please note that these procedures extract data directly from the MDB (Service Desk database) via simple query through a data source.
WARNING: Continuous running of such queries that run long or return too much data can cause performance issues to users logged on and working on the application.
Procedures
- Open a new clean Excel file
- Go to Data -> Import External Data -> New Database Query
- Select the fields you need and run the query (link tables if you have to)
- Export to Excel and save the file (If you already have the query somewhere, just follow the steps and instead of selecting the fields, you simply paste your query and run it then save the results to an excel spreadsheet)
Next time you want to run the same query to get the updated data, you simply do the following:
- Open the Excel file from the previous steps
- Go to Data -> Refresh Data (This will run the query and return the new data to the spreadsheet)
