Why could I not successfully import the XML file?
updated at
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
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:
- If your XML file does not contain inner tag, the import will run probably regardless of its size.
- Navicat does not support XML file which is of multiple level.
Have more questions?
-
Support
-
About Us