Hello,

I am trying import the data and column names from an xml file into an sql
2005 table. This is what I have used.


DECLARE @xml XML;
CREATE TABLE Products(xmlCol XML)
INSERT Products
SELECT CONVERT(XML, BulkColumn, 2)
FROM OPENROWSET (BULK 'C:\database\xmldtd\yahoostore.xml', SINGLE_BLOB) AS
Products

This creates the table, and inserts one column which takes a long time to
open, but seems to be empty.

Can anyone give me any suggestions? The xml file has dtd which I used the
convert for, but how do I get the columns and information from those colums.
This is xml file 93.2 mb. Is it too large?

Thank you
Dee