>Thanks Borislav and Brandon,
>
>I looked through and tried some of these ideas but most require the table structures to already be there. We tried to import from the VistaDB database also, but kept running into errors. I will probably just end up creating my own little routine to move the records.
>Thanks
>Tim


Based on second link I sent here, what about:

SELECT 'c:\TestXml.xml' AS XMLFileName, xmlData  INTO YourNewTable
FROM
(SELECT  * 
         FROM OPENROWSET (BULK 'c:\TestXml.xml', SINGLE_BLOB) AS XMLDATA
) AS FileImport (XMLDATA)

Again, not tested!!!!