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.
  1. Select the menu item Tools > Export Data > Export to Excel Spreadsheet or the Export to Excel Spreadsheet button from the main tool bar
  2. Select the open connection to use for this data export
  3. Select whether to export a single table or multiple tables
  4. For a multiple table export:
    1. 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
  5. Select the Next button to proceed to the next step
  6. Select the database catalog or schema containing the table(s) to be exported
  7. For a single table export:
    1. Select the table to be exported from the drop-down list
    2. Select the desired columns (or all) to be exported from the selected table
    3. Reorder the columns as desired using the Move up/down buttons
  8. For a multiple table export:
    1. Select the tables to be exported from the 'Available Tables' list using the arrow selection buttons
    2. Alter the order in which each table will be extracted using the Move up/down buttons
  9. Select the Next button to proceed to the next step
  10. Select a valid file path or paths for each individual table to be exported - or a single file path for single file generation
  11. Select the Next button to proceed to the next step
  12. Select whether to include table column names on the first row of the generated spreadsheet
  13. Select whether to map each column data type to the equivalent spreadsheet cell type
  14. Enter the individual sheet names for each extracted table (multiple table extract only)
  15. Select the Next button to proceed to the next step
  16. Select the action on error for the extraction process
  17. Select the Next button to begin the data extract process
  18. Monitor the output pane for any errors - use the Stop button to halt the process at any stage during the run
  19. Select Finish (or Back to correct errors etc) when the process has completed