Export to Microsoft Excel

Top  Previous  Next

Export Query Results To Microsoft Excel

 

NOTE: A prerequisite of this download option is that Microsoft Excel MUST BE LOADED ON YOUR PC.

 

 

Export_results_to_excel_dialog_box

 

A query has been executed and the results pane displays 100 lines of the result.  The Export icon Export_results_general_icon is selected and the Export dialog box is displayed.  The 'Whole Grid' option is selected and then the Export To browse button displays the Save As select screen.  This query will be saved to the Desktop as 'ExcelExport01' and file type 'Microsoft Excel (*xls)' selected.  Select Save to return the destination and type details back to the export options screen.

 

Export_results_to_excel_dialog_box1

 

While the export function is running the Export Status displays a function running bar.  On completion the exported Excel details are immediately displayed on screen.

 

Export_results_to_excel_result

 

As can be seen in the example, 100 lines of result (grid selection) are exported.

 

On completion the Export selection box shows Export Completed and the process is ended be selecting the Done button.

 

 

Export_results_to_excel_dialog_box2

 

The Excel results are displayed immediately in Excel.

 

NOTE: If Microsoft Excel is NOT installed on your PC then an error message is displayed:

 

 

 

 



Page URL: http://www.unitysolutions.com/Helps/UTB/HTML/index.html?export_to_microsoft_excel.htm