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


In Navicat, import of XML file is restricted to standard format as shown below :

<Records>
<Record>
<Field1>data</Field1>
<Field2>data</Field2>
<Field3>data</Field3>
<Field4>data</Field4>
<Field5>data</Field5>
</Record>
<Record>
<Field1>data</Field1>
<Field2>data</Field2>
<Field3>data</Field3>
<Field4>data</Field4>
<Field5>data</Fied5>
</Record>
</Records>

Note:

  1. If your XML file does not contain inner tag, the import will run probably regardless of its size.
  2. Navicat does not support XML file which is of multiple level.

Have more questions?
Submit Ticket