OPENXML can't natively go to the file system and retrieve a file. Your client code will have to pass the contents of the file to a stored procedure for processing.
-Mike
>Hello,
>
>I am playing with the OPENXML() Command and am pretty successfull with the examples. But one thing I wasen't able to figure out yet:
>
>
>DECLARE @idoc int
>DECLARE @doc varchar(8000)
>set @doc = '<ROOT>
> <row CustomerID="ALFKI" CompanyName="Alfreds Futterkiste" ContactName="Maria Anders" Country="Germany" />
></ROOT>'
>...
>
>
>How can I use a XML File out of the FileSystem instead of defining the XML File in the Stored Procedure?
>
>Marcus