tc3596
Technical User
- Mar 16, 2001
- 283
I am new to XML and was wondering how I could go about imnporting XML data into SQL Server via Visual Basic. In my reading, I learned about SQLXMLBulkLoad. However, this requires a schema and an xml file. Here is a snippet of the xml file shown below.
Questions I have:
1) is this the best and easiest way for me to accomplish my task?
2) if the schema is already defined (location of schema) in my xml document, why would I need to make a separate file for it? This leads me to think that I may need to use another method of importing this data instead of SQLXMLBulkLoad.
3) MS Access and MS Excel both let you easily import XML data by using the built in tools and it neither ask for a schema, so why does SQL Server need one?
<?xml version="1.0" encoding="UTF-8" ?>
- <AgileData xmlns=" xmlns:xsi=" xmlns:xsd=" xsi:schemaLocation=" - <ChangeOrders uniqueId="6000:6075604">
- <CoverPage>
<Number>ECO-00005</Number>
<Status>Released</Status>
<ChangeType>ECO</ChangeType>
<ChangeCategory>Standard</ChangeCategory>
<DescriptionOfChange>Release assemblies to prototype - 1000750, 1000823</DescriptionOfChange>
<ReasonForChange>New release</ReasonForChange>
<ReasonCode>New Release</ReasonCode>
<Workflow>Default Change Orders</Workflow>
<ChangeAnalyst>Susan Jennings (sjennings)</ChangeAnalyst>
<Originator>Sam Jones (sjones)</Originator>
<DateOriginated>2008-03-14T01:13:11Z</DateOriginated>
<DateReleased>2008-03-14T18:43:58Z</DateReleased>
If I need to adddress this in the Visual Basic forum, please advise. Thank you for your time.
Tim
Questions I have:
1) is this the best and easiest way for me to accomplish my task?
2) if the schema is already defined (location of schema) in my xml document, why would I need to make a separate file for it? This leads me to think that I may need to use another method of importing this data instead of SQLXMLBulkLoad.
3) MS Access and MS Excel both let you easily import XML data by using the built in tools and it neither ask for a schema, so why does SQL Server need one?
<?xml version="1.0" encoding="UTF-8" ?>
- <AgileData xmlns=" xmlns:xsi=" xmlns:xsd=" xsi:schemaLocation=" - <ChangeOrders uniqueId="6000:6075604">
- <CoverPage>
<Number>ECO-00005</Number>
<Status>Released</Status>
<ChangeType>ECO</ChangeType>
<ChangeCategory>Standard</ChangeCategory>
<DescriptionOfChange>Release assemblies to prototype - 1000750, 1000823</DescriptionOfChange>
<ReasonForChange>New release</ReasonForChange>
<ReasonCode>New Release</ReasonCode>
<Workflow>Default Change Orders</Workflow>
<ChangeAnalyst>Susan Jennings (sjennings)</ChangeAnalyst>
<Originator>Sam Jones (sjones)</Originator>
<DateOriginated>2008-03-14T01:13:11Z</DateOriginated>
<DateReleased>2008-03-14T18:43:58Z</DateReleased>
If I need to adddress this in the Visual Basic forum, please advise. Thank you for your time.
Tim
