Check SQLXML for SQL Server 2000 at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/anch_SQLXML.asp

>We need to import data from a XML file into a table of sql server database.
>
>As I know, we could use OPENXML. Could we use other methods?
>
>Could we read directly from a XML file instead of using @doc like in following example?
>
>DECLARE @idoc int
>DECLARE @doc varchar(1000)
>SET @doc ='
>
>....
> '
>EXEC sp_xml_preparedocument @idoc OUTPUT, @doc
>SELECT *
>FROM OPENXML
>EXEC sp_xml_removedocument @idoc
>
>