Export Data

 

SQL4X Manager J supports export of full tables and SQL query results in a variety of file formats.

 

Export full tables

 

Select your Export Table

To export a complete table select the table with the Database Navigator and click on "Export" in the toolbar. For a list of available export options see below.

 

Export SQL query results

 

Run your SQL query and select export

To export the result set of a query run the query with SQL Viewer and click on "Export" in the toolbar. For a list of available export options see below.

 

Export options / file formats

CSV/Text  

Text based export with variable field and record delimiter characters. Supports tab, colon, semicolon and comma as field delimiters and Unix, PC (DOS/Windows) and Mac line break as record delimiters.

If you want to export text fields which possibly contain one of the delimiter characters specify an "Optionally enclosed by" character to enclose text fields. Usually this is ' or ".

CSV formats can be read by almost any application. The produced CSV file includes column headers if you check "Include column titles".
     
Tab delimited   Basically a type of CSV format with tab as field delimiter. Best CSV format as all other record delimiter characters are part of many text and number fields.
     
Microsoft Excel Import   Basically a type of CSV format, but pre-configured to be directly recognized by Microsoft Excel. The saved file is double-clickable and opens in Excel.
     
HTML (CSS)  

HTML export with style sheets (CSS) for table formatting. CSS formatting can easily be modified by your favorite HTML editor. The following CSS definitions are used:

tblHead   Formatting information for table head (column names). Includes formatting for font and colors.
     
tblAlternate1   Formatting information for first alternating line.
     
tblAlternate2   Formatting information for second alternating line.

HTML tables are created with alternating line colors. tblAlternate1 and tblAlternate2 define the two colors and the fonts for the table content. If you do not want the resulting table to have alternating line colors change the color of both styles (tblAlternate1 and tblAlternate2) to the same color.
     
XML   Standard compliant XML 1.0 export to be read by any XML enabled application.