|
|
|
|
|
|
|
|
- Overview
- Exporting the result of a select query
- Exporting the result of a select query to a text file
- Exporting the result of a select query to a Excel, Word or XML
- Printing the result of a select query
WDSQL: Exporting and printing the result of an SQL query
The result of a select query can be: - exported to a file (text, Excel, XML or Word),
- printed.
Remark: For the following operations, we consider that the query result is displayed in WDSQL. Exporting the result of a select query Exporting the result of a select query to a text file To export the result of a select query to a text file: - Click the "Export" button. The window for selecting the text file is displayed.
- Specify the name and location of text file (".TXT" extension by default).
- Choose the type of separator used between the different items of each record ("Type" option):
- Separator: Tabulation: The items will be separated by tabs.
- Separator: Semicolon: The items will be separated by semicolons.
- Validate. The records found in the query result are automatically exported to the text file.
Exporting the result of a select query to a Excel, Word or XML To export the result of a select query to Excel, Word or XML: - Right-click the table containing the query result.
- Select the requested export mode: Word, Excel or XML.
- Specify the name of export file and validate.
Printing the result of a select query To print the result of a select query: - Click the "Print" button. The window for selecting the items to print is displayed.
- Specify the items to print and validate. The query result is displayed in a print preview.
- Click
 to print the query result.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|