Import XML in SQL Server 2000

How to import XML file in SQL, without knowing the structure of XML
data. I tried the OPENXML function but the XML contains more than 150
tables and I can't write the schema of all of them. Is there any other
way creating database structure from XML file and inserting its data?

thanks

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • RE: MS patch-scanner for Win-NT, 2K, IIS, SQL
    ... MS patch-scanner for Win-NT, 2K, IIS, SQL ... XML file from the following location - mssecure.xml Possible ... and on a NT 4 Server, but the scanner works fine on a W2K Server ...
    (Focus-Microsoft)
  • RE: MS patch-scanner for Win-NT, 2K, IIS, SQL
    ... MS patch-scanner for Win-NT, 2K, IIS, SQL ... seems so far that the patches it suggests are accurate. ... it the patch for advisory MS01-015 is not istalled, ... verison of the binary or the xml file at any of the URLs I've been given. ...
    (Focus-Microsoft)
  • Re: ADO.NET questions
    ... Sure, you can use XML to move data to and from SQL Server, but it's very ... >>> have a way to export rows from a few tables from one users computer to ... >>> email xml file to another user) ... >>> 5)Create SQLDataAdapter on target computer. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Looking for database design/model software
    ... > generate SQL, ... Since Dia ... I actually have a small PHP script that takes the input of ... feed it into another script that turns it an XML file for Dia. ...
    (RedHat)
  • Re: OO vs. RDB challenge
    ... >> strict adherence only to the SQL oriented challenge? ... The groups XML file may change in structure, new fields may appear, old ... schema doesn't map easily to systems requiring a more rigid schema. ...
    (comp.object)