Can I import data from a XML file into a table in SQL?

Answer 1

You'll have to translate it into a flat file if you want the individual XML elements to transform into counterpart rows and columns of various tables.

There are RDBMS out there that allow you to store XML or now even JSON as a data type, like integers or chars

Answer 2

you could do it in Microsoft SQL .... probably you could do this with MySQL ....XML is a format for storing and delivering data and it can easily simulate a SQL table