Import a XML-file..?

[kenjoswe]

Hi all,

I have a XML-file that I would like to import into a single SQL-table.
What would be the step-by-step procedure?

I have read 'Writing XML Using OPENXML' in books online.
I understand that I first have to prepare the document with:
sp_xml_preparedocument
and then run.....
OPENXML

Sorry but I don't get it!

/Kent J.

 

[HamotIntern]

I too am having problems using OPENXML. Perhaps by replying to this, the thread will surface to the top again and perhaps someone who understands OPENXML will help the both of us.