With SQL Complete, you can copy data from a cell or an entire table in the results grid to clipboard or to a CSV, XML, HTML, or JSON file.
To copy data from the results grid, select the values you want to copy, right-click them and select Copy Data As > file format (CSV, XML, HTML, or JSON) > To File or To Clipboard.
Alternatively, you can use shortcuts to copy data to the clipboard for a specific file format:
If you want to copy column names from the grid, select the columns you want to copy, right-click and select Copy Data As > Copy Column Names Only or press Ctrl+Alt+Y,N.
If you want to copy column names and types of their values from the grid, select the columns you want to copy, right-click and select Copy Data As > Copy Column Names and Types or press Ctrl+Alt+Y,T.
Let’s take the CSV format as an example and see how SQL Complete copies data to clipboard.
The output is as follows:
680,FR-R92B-58,Black,375,"1,431.50"
706,FR-R92R-58,Red,375,"1,431.50"
707,HL-U509-R,Red,3,34.99
708,HL-U509,Black,3,34.99
709,SO-B909-M,White,3,9.50
If you need to copy data from a column, add a selection from an empty row, as shown in the screenshot below.
Then, copy it to the clipboard in the required format. The output is as follows:
FR-R92B-58,
FR-R92R-58,
HL-U509-R,
HL-U509,
SO-B909-M,
1. In the SQL Complete menu, select Options.
2. In the SQL Complete: Options dialog, switch to Data Export > CSV and configure data export to the CSV file format.
Option | Description |
---|---|
Use Unicode | Creates a .csv file with a Unicode character encoding. |
Show a table header | Indicates whether to write column headers. |
Quote string | Encloses a string in quotes. The recommended options are single quote mark or double quote mark. |
Force quote | Indicates whether quoting should be optional (if cleared) or added at all times (if selected). |
Field separator | Defines a field separator by using one of the available options: comma, semicolon, Tab, or Space. |
3. To save changes, click OK.