inserting some data from xml file to sql server
(....this has also been pasted in the database section)
I have an xml file, i wish on a regular basis to collect the data from the file to insert into the sql server database:
1. create a ado recordset and insert all necessary data from the xml file to the recordset
2. insert the recordset to to tha appropriate table within the sql server.
is this idea possible? if so how do i do it? I am using vbscript in asp.
I know that sql returns ado recordsets, can it take ado recordset?
Would appreciate any answers that help towrds solving my problem.