Does anyone know of a utility or program code to convert XML to MS SQL?
Who is Participating?
Eddie ShipmanConnect With a Mentor All-around developerCommented:
Well, there is a problem with schemas. If they do not match, you won't be able to use DTS. You are going to
have to have some kind of "mapper" to assign the correct XML fields to the corresponding MSSQL fields.

I believe the XMLDataMapper does that but I only have D6 Pro so I can't create you a sample.
Why did you post this under delphi?

You can use the import functions in MSSQL manager to import your data, or you could set up a DTS if you want to make a standard procedure out of it.
Wim ten BrinkSelf-employed developerCommented:
XML is just a data format. All you have to do is read the data from the XML file and insert it into records in your SQL database. But I feel you need something more specific so please, be more specific, okay?
CalvinDayAuthor Commented:
You are right. I should have asked this question under the XML area.

However, I do want to open the XML file and insert it. I am using MS SQL administrator and do not know how to link to this file. I have tried to import the data but I get some error from CR XML 3.6 ODBC driver but get errors when it is accessed.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.