Yea, we tried that. Almost but some of the columns had data longer than the spreadsheet would accept. Didn't trust the data so we gave up on that. Thanks
Tim
>Could you push it into Excel 2007 and then push from there using the import wizard from SQL.... Just a thought.
>-R!
>
>>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
>>
>>>>Hi all,
>>>>
>>>>We need to import an XML with schema into a new database on SQL Server 2008. It appears there are some methods of doing this that seem a bit involved. Since this is basically a one time move from one data source into XML and then into SQL server it isn't very appealing to go through 38 steps of creating stuff. I would have hoped there was a import from xml file in SQL server but can't find any such thing.
>>>>
>>>>Does anyone know of a simple import solution?
>>>>Thanks
>>>>Tim
>>>
>>>
>>>
http://support.microsoft.com/kb/316005>>>
http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspx>>>None of them tested :-)
Timothy Bryan