 |
Exporting Data to Excel Spreadsheet Files
|
 |
The Export to Excel Spreadsheet File feature allows for the extraction of
table data to Excel spreadsheet format using multiple sheets and other
spreadsheet specific features.
|
 |
- Select the menu item Tools > Export Data > Export to
Excel Spreadsheet or the Export to Excel Spreadsheet button from
the main tool bar
- Select the open connection to use for this data export
- Select whether to export a single table or multiple tables
- For a multiple table export:
- Select whether to generate one file that includes ALL
extracted tables within individual sheets or multiple files
where a single file is used for each individual table
- Select the Next button to proceed to the next step
- Select the database catalog or schema containing the table(s) to
be exported
- For a single table export:
- Select the table to be exported from the drop-down list
- Select the desired columns (or all) to be exported from the
selected table
- Reorder the columns as desired using the Move up/down
buttons
- For a multiple table export:
- Select the tables to be exported from the 'Available Tables'
list using the arrow selection buttons
- Alter the order in which each table will be extracted using
the Move up/down buttons
- Select the Next button to proceed to the next step
- Select a valid file path or paths for each individual table to be
exported - or a single file path for single file generation
- Select the Next button to proceed to the next step
- Select whether to include table column names on the first row of
the generated spreadsheet
- Select whether to map each column data type to the equivalent
spreadsheet cell type
- Enter the individual sheet names for each extracted table
(multiple table extract only)
- Select the Next button to proceed to the next step
- Select the action on error for the extraction process
- Select the Next button to begin the data extract process
- Monitor the output pane for any errors - use the Stop button to
halt the process at any stage during the run
- Select Finish (or Back to correct errors etc) when the process
has completed
|