Apply OS: Windows, Mac, 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.
  2. Follow the Steps in Export Wizard which guides you through
    • Settings Export File Format (Step 1)
    • Setting Destination File Name and Encoding (Step 2)
    • Setting Data Format (Step 4)
    • Saving and Confirming Export (Step 5)
  3. In Step 5, save this export as a profile.
  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.

Have more questions?
Submit Ticket