Why I could not import the XML file successfully?
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
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:
- 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