OpenXML query

I am trying to create a stored procedure which opens a file in say location
'C:\xml'
and then pass the content of this opened xml file once opened to OPenXml
does anyone know how to do this.
Thanks in advance.
You would have to write an extended stored proc or use the sp_OA stored
proc. In SQL Server 2005, there will be an easier way to read from a file...
Best regards
Michael
"gee57" <gee57@.discussions.microsoft.com> wrote in message
news:E0CBF1EB-2D62-45D5-8C82-A20C3BAC1876@.microsoft.com...
>I am trying to create a stored procedure which opens a file in say location
> 'C:\xml'
>
> and then pass the content of this opened xml file once opened to OPenXml
> does anyone know how to do this.
> Thanks in advance.