How do I export a query to a file?

Question

Procedure Log in to the OnCommand Insight web UI. Click Queries and select Show all queries. The Queries page is displayed. Click a query. Click to export query results to a. CSV file. Do one of the following: Click Open with and then OK to open the file with Microsoft Excel and save the file to a specific location.

How do I export SQL query results to a file?

To export query results (Interactive SQL Data menu)1Enter your query in the SQL Statements pane of Interactive SQL.2Choose SQL » Execute.3Choose Data » Export.4Specify a location for the results and click Next.5For text, HTML, and XML files, type a file name in the File Name field and click Export. ... 6Click Close.

How do I save a query result to a file?

Here's how.1Query Results. Run a query. Now right-click in the Results Pane and select Save Results As... from the contextual menu.2Save the File. Name the file and location and click Save .3Open the File. Now locate the file and open it in Notepad (or your preferred application for opening CSV files).

Can you export a query?

You can export a table, query, form, or report. You can also export selected records in a multiple-record view, such as a datasheet.

Expert · Answer