Exporting query results to a CSV or Microsoft Excel spreadsheet file

 Exporting query results to a CSV or Microsoft Excel spreadsheet file :



Procedure

1.    Type your query in the SQL Statements pane of Interactive SQL.

2.    At the end of the query, choose one of the following options:

Option

Specify the OUTPUT statement

Export an entire table

For example:

SELECT * FROM TableName;

OUTPUT TO 'filepath';

Export query results and append the results to another file

Specify the APPEND clause:

SELECT * FROM TableName;

OUTPUT TO 'filepath'

APPEND;

Export query results and include messages

Specify the VERBOSE clause:

SELECT * FROM TableName;

OUTPUT TO 'filepath'

VERBOSE;

Append both results and messages

Specify the APPEND and VERBOSE clauses:

SELECT * FROM TableName;

OUTPUT TO 'filepath'

APPEND VERBOSE;

Export query results with the column names in the first line of the file

Note If you are exporting to a Microsoft Excel file, then the statement assumes the first row contains the column names.

Specify the WITH COLUMN NAMES clause:

SELECT * FROM TableName;

OUTPUT TO 'filepath'

    FORMAT TEXT

    QUOTE '"'

    WITH COLUMN NAMES;

Export query results to a Microsoft Excel spreadsheet

Specify the FORMAT EXCEL clause:

SELECT * FROM TableName;

OUTPUT TO 'filepath' FORMAT EXCEL

3.    Click SQL Execute.


Example

The following statement exports the contents of the Customers table from the sample database to a Microsoft Excel workbook called customers.xlsb:

SELECT * FROM Customers;
OUTPUT TO 'Customers.xlsb' FORMAT EXCEL