It's a simple idea, but I can't find anything straightforward that I can do. I'd like to do this without using a 3rd party product.

Using the DTS Import functions don't seem to be the answer.

Has anyone imported an xml doc to a SQL table successfully?

Thanks in advance for your comments

I think that sql 2005 may have xml functionality might look there but I am not sure. If not many external languages(non sql/rdbms) have XML parsing abilities like Java, Flash action script, etc. You may just need to use one of those languages to parse the data then you can insert it into the database.

Sorry, I should have mentioned that I'm using SQL 2000.

I'm hoping to avoid writing a script, because this particular file has a complicated structure to it.

Hi,

I have done it in the past using OPENXML in sql 2000. Or maybe just do an insert using a text field type in sql 2000.

CPall

I tried to work a solution by using the ReadXML method of a dataset; that didn't work out. I eventually punted and tried doing a simple import into Excel and it worked perfectly. I was then able to quickly use DTS to import the spreadsheet. Fortunately, the recordset was only about 17,000 rows so I didn't have to worry about overflow with the spreadsheet (65,536 rows max).