Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import XML file into existing table
Message
 
 
To
16/12/2008 20:52:39
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01367990
Message ID:
01367993
Views:
7
>Hi All,
>
>I have an XML file created from another database table. I also have a table in SQL server that I want to import these records into. Is there an easy way to do this in SQL Server Management Studio? This is just a one time thing where I am trying to move all my existing records to SQL Server.
>Thanks for helping.
>Tim

Tim,

Just google "Import XML SQL Server" and you'll get a lot of hits.

http://www.sqlservercentral.com/articles/Miscellaneous/importingxmlfilesintosqlserver/2262/

http://support.microsoft.com/kb/316005
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform