Batch import XML files to SQL Server tables

by

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

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

Download Withdata FileToDB Download FileToDB

Bulk import XML files into SQL Server tables

Login to SQL Server -> Choose XML files -> Set SQL Server tables -> Import XML files to SQL Server tables

Choose SQL Server and logon.

bulk import XML files into SQL Server tables - Choose SQL Server and logon

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

bulk import XML files into SQL Server tables - task window

Select the “XML” file type.

bulk load XML files into SQL Server tables - select file type

then show the wizard.

1. Select a folder that constains XML files.

bulk import XML files into SQL Server tables - select a folder

2. Config first XML file importing options.

bulk import XML files into SQL Server tables - config first file

3. Set “Import Type”.

bulk import XML files into SQL Server tables - set tables

4. Map SQL Server tables to XML files.

bulk import XML files into SQL Server tables - map

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

bulk import XML files into SQL Server tables - preview

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

bulk import XML files into SQL Server tables - import data

View imported data in SQL Server table

bulk import XML files into SQL Server tables - view data


More about XML to SQL Server converter

See also: