Navicat allows the export of multiple tables into a single file. This feature supports the CSV, text and Excel file formats. In this tutorial, we will show you how to export multiple tables into one text file with the export wizard. To begin, start an export wizard in Navicat and follow the steps. In step 1, you can select the file type of the text file. In the next step, check the tables that you want to export. Set the same export location and file name for them. In step 3, select the table fields to be exported. By default, all the fields in the list are selected. Select the “Append on output file(s)” option in step 4 to append the records in the output file. Then, click the “Start” button in the last step. Messages will follow to display the success or failure of the process. Finally, click the “Save” button to save the export wizard profile and close the window when the process is completed.
