Apply OS: Windows, macOS, Linux

Apply Navicat Product: All

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 and click Export Result/Export in toolbar.
    WinExportQuery01.png
  2. Follow the Steps in Export Wizard which guides you through
    • Settings Export File Format
      WinExportQuery02.png
    • Setting Destination File Name and Encoding
      WinExportQuery03.png
    • Setting Data Format
      WinExportQuery04.png
    • Saving and Confirming Export
      WinExportQuery05.png
  3. In the last step, save this export as a profile.
    WinExportQuery06.png
  4. 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.
    WinExportQuery07.png

Have more questions?
Submit Ticket