import XML into table

[vincer]

Hello,
DTS provides a mechanism to export a table to an XML file.
How can I bulk insert this file back into the table?

Ideally I want to do this using an sql statement using ADO technology.

I've tried using the DTS import but do not know what to specify as the provider and connection properties.

I am using SQL2000

Many thanks

Vince