Batch import XML files to Oracle tables

by

Want to bulk import XML files into Oracle tables at one time?

Try Withdata FileToDB, a desktop XML to Oracle converter for Windows, MacOS, and Linux, Convert XML to Oracle, Easy and Fast.

Download Withdata FileToDB Download FileToDB

Bulk import XML files into Oracle tables

Login to Oracle -> Choose XML files -> Set Oracle tables -> Import XML files to Oracle tables

Choose Oracle and logon.

bulk import XML files into Oracle tables - Choose Oracle and logon

Click “Wizard – N Files To N Tables” at task dialog.

bulk import XML files into Oracle tables - task window

Select the “XML” file type.

bulk load XML files into Oracle tables - select file type

then show the wizard.

1. Select a folder that constains XML files.

bulk import XML files into Oracle tables - select a folder

2. Config first XML file importing options.

bulk import XML files into Oracle tables - config first file

3. Set “Import Type”.

bulk import XML files into Oracle tables - set tables

4. Map Oracle tables to XML files.

bulk import XML files into Oracle tables - map

5. Summary. Set “Convert Rows” and “Skip Rows” if need.

bulk import XML files into Oracle tables - preview

6. Import XML files to Oracle tables, 1 file to 1 table, one by one.

bulk import XML files into Oracle tables - import data

View imported data in Oracle table

bulk import XML files into Oracle tables - view data


More about XML to Oracle converter

See Video: Batch import XML to Oracle

See also: