Want to upsert data from XML file to SQL Server ?
Using XmlToMsSql, you can upsert data from XML file to SQL Server easily and fast, no need to program, just a few mouse clicks!
Upsert data from XML file to SQL Server
Click “Wizard For Importing” at task dialog.
then show the wizard.
1. Open a XML file.
2. Select a table and config fields.
Set “Load Type” to “Upsert”, choice “Update Key”.
3. Preview data.