Page History

...

1. Start Microsoft Office Excel 2003.
2. On the Data menu, click Import External Data, then click New Database Query.
3. The Choose Data Source dialog box is displayed:

   Image RemovedImage Added

   On the Databases tab, select the up.time ODBC data source.

   The name of the data source in the list is the name you gave the up.time DataStore when you created its profile in the ODBC Data Source Administrator Control Panel (in this example, the database is simply named "uptime").

   Click OK.

4. The Query Wizard appears:

   Image RemovedImage Added

   Choose the columns (and tables) to include in your query, then click Next.
5. For the Filter Data Wizard step, if desired, provide specific rows to include in your query, then click Next.
6. For the Sort Order Wizard step, if desired, indicate how the data will be sorted, then click Next.
7. On the final Wizard step, opt to View data or edit query in Microsoft Query, then click Finish.
8. The Import Data dialog box is displayed:

   Image RemovedImage Added

   Click Edit Query to open Microsoft Query and preview the retrieved data:

   Image RemovedImage Added

9. Click the View menu, then click SQL to display the query. The columns you selected in the Query Wizard (step 4) will be displayed as the SQL statement:

   Image RemovedImage Added

10. Edit the SQL statment to refine which of the data from the selected columns will be used in the Excel sheet, then click OK to return to Microsoft Query.
11. Click File, then click Return Data to Microsoft Office Excel.

...