Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for MariaDB, Navicat for SQLite, Navicat for MongoDB, Navicat Premium

Apply Navicat Version No.: All


Please follow the steps below (Windows version)

Example: Export query results to a text file

  1. After running the query, save the query.

  2. In the menu bar, choose File -> Export Result.
  3. Click Export Saved Query / Export from Saved Query.
  4. Follow the Steps in Export Wizard which guides you through
    • Settings Export File Format
    • Setting Destination File Name and Encoding
    • Setting Data Format
    • Saving and Confirming Export
  5. In the last step, save this export as a profile.
  6. Create a batch job and set task schedule for this profile. This would export the query results to the destination file at a specific time you like.

Have more questions?
Submit Ticket