Difference between revisions of "MS Excel"

From SDU
Jump to: navigation, search
(New page: Below is a list of steps to extract data from ServiceDesk and export to MS Excell file. Please note that this extracts data directly from the MDB (ServiceDesk database) via simple query th...)
 
m
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
Below is a list of steps to extract data from ServiceDesk and export to MS Excell file. Please note that this extracts data directly from the MDB (ServiceDesk database) via simple query through a data source.
+
__NOTOC__
 +
[[Category:r6]]
 +
[[Category:r11]]
 +
[[Category:Reporting]]
 +
{{Global Header}}
 +
{{Global Announcement}}
  
−
'''WARNING''': Continous running of such queries that run long or return too much data can bring cause performance issues on users logged on to the application.
+
== See Also ==
−
 
+
[[Exporting From DB to Excel]]
−
1. Open a new clean Excel file
+
−
+
−
2. Go to Data -> Import External Data -> New Database Query
+
−
+
−
3. Select the fields you need and run the query (''link tables if you have to'')
+
−
+
−
4. 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:
+
−
 
+
−
 
+
−
1. Open the Excel file from the previous steps
+
−
 
+
−
2. Go to Data -> Refresh Data (This will run the query and return the new data to the spreadsheet)
+

Latest revision as of 06:24, 6 August 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.

See Also

Exporting From DB to Excel

Retrieved from "http://greggsmith.net/wiki/index.php?title=MS_Excel&oldid=2948"