SQLTeam.com | Weblogs | Forums

Import XML to SQLite3 Database

xml
sql2014

#1

Hi guys,

I am new here. I need some help. I can't find any real material showing me how to import an XML file to my Database. I need some help tough. I have an xml file that can be found here:
XML fomat:
https://webgate.ec.europa.eu/europeaid/fsd/fsf/public/files/dtdFullSanctionsList/content?token=dG9rZW4tMjAxNw
DTD format:
https://webgate.ec.europa.eu/europeaid/fsd/fsf/public/files/dtdFullSanctionsListSchema/content?token=dG9rZW4tMjAxNw

I am new to importing files in SQL DB so i need some help on how to create the tables and how to import this big file automatically. If someone can help me, i would owe you a lot!

Thanks!


#2

Most people, understandably, don't like to click on links and download files from unknown sources. That is probably why there have been no responses to your question. If you can post sample data and what you are trying to accomplish, you might get better responses.

There are several articles and blogs on importing XML data into SQL Server and on shredding XML into relational tables. For example, here.


#3

Thank you James! Just a short one! the code from that article works for SQLite3 DB?


#4

Try asking your question in a SQLLite Forum