Home
SQL Spreadsheets online help Prev Page Prev Page
Introduction
About SQL Spreadsheets
Version history
Contact us
Supported database engines
Using SQL Spreadsheets
Home page
SQL workbench
Command selection
Data sets
Exporting data sets
Exporting to text files
Exporting to Excel
Define column formats
Tasks
Task settings
DATETIME tag formatting options
Connect to database
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
SQL scripts
SQL tags
Image and file options
Define column formats
Delivery channels
Logging options
Finalise
Run task
Scheduling a task
Options

Exporting to text files

Click on the Export data sets to text files button (save) on the data sets toolbar. This will start the export process.

Select the data sets you want to export, and give each data set a unique file name. You can view the data contained in each data set by selecting the data set in the Available data sets
list.

sql_txt_01  
 
Select the file encoding type, and the delimiter to use. Select the Overwrite existing files option if you want to overwrite any existing files.
 
sql_txt_02  
 
SQL Spreadsheets will export the data sets to the text files you named, and report its progress. Once the export process has completed, you can open the text files by clicking on the Open file button.
 
sql_txt_03