I set up a filemontoringtool in vb.net

I want to monitor for xml files

store the xml data in a database

then move the xml files somewhere else ( or delete them im not sure yet)



Ive got steps 1 and 3 down


My question is to insert xml in sql server 2005 do you need to

open the file
read in the variable
then move the variables over

or is there a way to just chunk the file directly into the database?


ive never had any projects inserting data into a database (and only a few reading)


thanks for any help you can give.