Navicat imports TXT files to the database and navicat imports txt files.

Navicat imports TXT files to the database and navicat imports txt files.

1. Open the first line of txt and write the column name, otherwise there will be no column, such as username password

2. Select database-table, right-click and select import wizard

3. Select the TXT format and click Next.

4. Select Your TXT file path

5. Select the field separator of your TXT file. If it is separated by tab, select another file. Then press tab in notepad to copy the string and click Next.

6. Select a database and click Next.

7. The corresponding username and password columns are displayed, which indicates OK.

8. Select the import mode, click next, and then click Start.