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