Importing XML into SQL Server

[shadyness]

I do not even know where to start on this project, but I need at least a starting point or maybe an article or advice if someone has done something like this before. The project is this, I need to write a program that will go through all folders and sub folders of this single directory and take the XML file name and insert it into a column in a SQL Server 2000 database, and then import in all of the XML into the second column. So that the name minus ".xml" and all of the code are stored in the table.

Any help would much appreciated.


<== Some people say they are afraid of heights. With me its table widths. ==>

 

[ca8msm]

You will need to do a recursive search through a folder directory and look for any files with the extension of .xml. To do this try having a look (you can search on this forum and there will be lots of examples) at the File Scripting Object. This will allow you to both search through folders and look at the extension of each file.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.