>>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!!!!
I did keep this one in my sights. I got the impression it required the table structure to be already created but maybe not. I will try it both ways on one table and see if this will work for us.
Thanks
Timothy Bryan