• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 423
  • Last Modified:

XML to MS SQL

Does anyone know of a utility or program code to convert XML to MS SQL?
0
CalvinDay
Asked:
CalvinDay
1 Solution
 
mattisflonesCommented:
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.
0
 
Wim ten BrinkCommented:
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?
0
 
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.
0
 
Eddie ShipmanAll-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.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now