Saving Query in Cell

You can save the query as a Nexcel Query File (*.nxq) or an SQL File (*.sql) after running a query to import external data. Specifically, you can save the query file from the Query Wizard dialog box or the Edit Query dialog box.

Steps

To save a query in Cell

  1. Select Run Query or Create New Query from Data > Get External Data to launch the query wizard.
  2. From the Preview Query Result dialog box, which is the last query wizard step, select Save Query.
  3. From the Save As dialog box, click Save in and specify the save destination for the query file.
  4. Select the save format as follows:
  5. Click Save to save the query in the selected format.

See Also