Home
SQL Select online help Prev Page Prev Page
Introduction
About SQL Select
Version history
Supported database engines
Contact us
Using SQL Select
Connecting to a database server
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
The SQL workspace
SQL editor
Query selection
Data sets
Locking data sets
Exporting data sets
Export to text file
Export to Excel
Export to SQLite

Export to Excel

Click on the Export data sets to Excel button (file_excel_normal) on the data sets toolbar. This will start the export process.

Select the data sets you want to export. Each data set will be exported to a different worksheet. Thus, you need to give each worksheet a unique name. You can export both the active and locked data sets. You can view the data contained in each data set by selecting the data set in the Available data sets
list.

export_xls_01  
 
Enter the name of the Excel workbook to save the data sets in. You can also select various options with regards to how many rows should be stored on each worksheet, and how the header should be displayed.
 
export_xls_02  
 
SQL Select will export the data sets to the Excel workbook you named, and report its progress. Once the export process has completed, you can open the Excel file by clicking on the Open workbook button.
 
export_xls_03