Hi! Can anyone point me to any tutorials, applications, or advice that will allow me to read xml files, make some changes to them and insert them into a MS SQL database (possibly MS SQL 2005).

This will be run on a Windows server and I'd prefer to do this in ASP (with the help of scheduled tasks) but if another alternative is out there, I wouldn't mind hearing it. The script would be run on an hourly basis to check for new xml files and import them as needed.

I've been reading up on this and can do everything except work out how to read the xml in asp and populate an insert statement based on the contents of the xml file so any advice would be greatly appreciated.

Now, back to my googling!

Rgds,

Dave

__________________
David Behan
Web Design | Mortgages | Memorial Websites | Digital Printing | Golf Holidays Portugal | Conservatories