The "right" direction would be SQL 2005, however, it sounds like you are
stuck. You treat XML as text or BLOB data in SQL 2000. How you do this
will depend on the format of the data you are importing.

For example, if you have a bunch of individual XML files and you need to
put this in a table along with additional "normal" data, you might do
better to write a VB or C# application to create rows and get the XML
for insert with a fileReader object.

I have been doing lots of XQuery and XML DML work and, frankly, I think
it is easier to handle with .NET.

HTH
Mike

-----Original Message-----
From: Albert Frazer
[mailto:mssqldba-ezmlmshield-x38989476.[Email address protected]
Sent: Wednesday, February 28, 2007 1:28 PM
To: LazyDBA Discussion
Subject: RE: xml import urgent help

Anyone at least can point me to the right direction?

Albert Frazer
Home Decor Products, Inc
www.hdpi.com
732-593-3637 (office)
732-570-4465 (cell)

-----Original Message-----
From: Albert Frazer
[mailto:mssqldba-ezmlmshield-x17113582.[Email address protected]
Sent: Wednesday, February 28, 2007 1:33 PM
To: LazyDBA Discussion
Subject: xml import urgent help

I need to import XML file into SQL Server 2000. Can anyone help me with
this?





Albert Frazer

Home Decor Products, Inc

www.hdpi.com <http://www.hdpi.com>

732-593-3637 (office)

732-570-4465 (cell)





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page