Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 i am try to read mutliple xml file

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-17 : 08:42:10
patelnimisha writes "i am try to read three xml files and transfer its data into sql databse.
so
i have no any idea about this qurey.
give me coding for this query"

Kristen
Test

22859 Posts

Posted - 2006-02-17 : 13:15:22
Hi patelnimisha, Welcome to SQL Team!

You are probably best off with Microsoft's XML Bulk Load Component

http://support.microsoft.com/?scid=316005

(Not a very up to date link, current version is 3 (or maybe even 4!!) I think, but that will give you an idea)

Kristen
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-20 : 01:09:52
Also to read multiple files and import them. Refer this and get idea(This is for text files)
http://www.nigelrivett.net/SQLTsql/ImportTextFiles.html

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -