Re: Importing data into MS SQL 2000 from XML file

To: markc600
Re: Re: Importing data into MS SQL 2000 from XML file
By: markc600 to comp.databases.ms-sqlserver on Fri Jun 09 2006 09:31 am

From Newsgroup: comp.databases.ms-sqlserver


I've noticed you have 'Units' and 'units' - XML is often (always?)
case-sensitive so this may not work.

--- Synchronet 3.13b-Linux NewsLink 1.84

Hi Marc,

Thanks for the reply, and I'll check this out. Since making my post
earlier I've gotten my import to work, but to a point.

My XML file starts with this:
<?xml version="1.0" ?>
<vendor_database xmlns="http://www.vendorurl.com";>
-snip-

and here's how my schema.xml file starts ...

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">

<xsd:element name="vendor_database" sql:is-constant="true" >
-snip-

If I remove the xmlns entry from the XML data file the import runs fine,
but leaving it in there the import runs but nothing is imported. How do I
work this into the schema file? This vendor file is downloaded
automatically and no way to have this entry deleted from the xml file I"m
importing into my database.

So at this point it's just about there, just need to figure how what to do
with the xmlns entry.

Thanks --

Sam


---
Sam Alexander - sam.alexander(at)sidebandbbs(dot)com
http://www.samandflip.com or telnet://sidebandbbs.com
---
"Data is not information, Information is not knowledge, Knowledge is not
understanding, Understanding is not wisdom." -- Cliff Stoll

--- Synchronet 3.13b-Linux NewsLink 1.84
--[SideBand BBS - telnet://sidebandbbs.com]--
.

Relevant Pages

  • Re: speeding up a file conversion from text file to XML format
    ... to try and improve the importing of files into SQL for old legacy ... The file are submitted to the company by FTP, ... I have written a module to convert this file into an XML file which ... imports to the SQL very quickly. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: speeding up a file conversion from text file to XML format
    ... to try and improve the importing of files into SQL for old legacy ... I have written a module to convert this file into an XML file which ... 4000 data records (data recorded marked for with *** for ... It seems like most of the activity is adding the Transaction XmlElement 4000 ...
    (microsoft.public.dotnet.languages.vb)
  • Import XML File - Field Overwrite Issue
    ... When importing an XML file, it is overwriting data if there are mulitple ... When importing the above, only the second "Note" appears rather than both. ... What I need it to be is: "Remove and discard blade cover. ...
    (microsoft.public.access.externaldata)
  • RE: XML into Access 2003
    ... Dim f As FileDialog ... Check the help files of the importxml method if you need to import ... I am working with Access 2007 and importing an xml file, ... Since Access 2003 doesn't provide for importing xml, ...
    (microsoft.public.access.externaldata)
  • RE: using schema.ini to write to file
    ... Based on my understanding, you have read from a text file through ADO.net ... you have to write it like a normal text file through TextWriter. ... I recommanded you to use XML file or accessfile or even Excel file ...
    (microsoft.public.dotnet.languages.csharp)