How to export data from the results grid

Query Builder allows selecting and exporting data from the results grid.

Selecting data in the results grid

You can select data from the results grid in one of the following ways:

Move the mouse pointer across the grid holding the left mouse button.
Click the first cell of the required data range, press the SHIFT key, hold it and click the last cell. A rectangular range of cells will be selected.

Right-click the selected data and click Export Data to invoke the Data Export Wizard. Alternatively, you can open it by clicking Export Data at the top of the grid.

Note

Query Builder comes with Paginal Mode enabled by default, limiting the selection to the first 1000 records. In order to export more records, disable the Paginal Mode and press Ctrl+End to fetch all the selected data at once. This will ensure that all the data is loaded into the Query Builder. Then, you can click Export Data at the top of the grid to launch the Data Export Wizard.

By following these steps, you can bypass the default limitation and export the desired data from Query Builder.

Exporting data from the results grid

Using Query Builder, you can export data to a variety of formats:

Additionally, you can save and use data export templates for recurring scenarios.

Want to Find out More?

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Query Builder for SQL Server.

Request a demo

If you consider employing the Query Builder for your business, request a demo to see it in action.

Ready to start using dbForge Query Builder for SQL Server?

Download a free 30-day trial