How to import from XML file in SQL Server Import and Export Wizard?

sql-server vistadb sql-import-wizard
finch picture finch · Mar 9, 2014 · Viewed 7k times · Source

I have data and schema for a table as a single XML file. How do I import this using the SQL Server Import and Export Wizard?

Should I use a "Flat File Source" as my Data Source? Or what?

[For info, I exported the XML from VistaDB, but I have not yet got as far as the point where the system which created the data might be an issue.]

Answer

Karl Kieninger picture Karl Kieninger · Mar 10, 2014

As far as I know, you cannot do this by using a the import export wizard. Assuming you want the data to wind up all relational rather than as XML datatype, you'll need to create the table and use sp_xml_preparedocument and OPENXML.

See How to use OPENXML to load XML data into existing SQL Table?

Related questions

What are the advantages of VistaDB

I have seen the references to VistaDB over the years and with tools like SQLite, Firebird, MS SQL et. al. I have never had a reason to consider it. What are the benefits of paying for VistaDB vs using another …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More