adpersistxml - updating database w\ disconnected recordset

From: rqcoder (rqcoder_at_discussions.microsoft.com)
Date: 07/22/04 

Date: Wed, 21 Jul 2004 18:09:02 -0700

Is there a way to update an existing table in an access database with a recordset that was created using an xml file (i.e. adpersistxml) without iterating through every record?

Am applying an xml transformation to an xml file supplied by a third party application. The file is transformed it to an xml file using the same schema that ado uses to save xml files. I'm successfull in loading the xml file into a recordset however now I need to insert those records into an existing table of an Access database. I know I can iterate each record of the recordset and use the fields collection but this takes too long. Is there another way to do it, like inserting the whole recordset into the table?

Thanks for any info in advance...

Relevant Pages

  • Re: how to process data when internet connection broken?
    ... recordset, persist it to an XML file, then open the XML file locally as a ... recordset and manipulate the data as required. ... > So, looks that Microsoft Message Queing can solve this problem, am I ... >>> DataSet) and update the SQL server and local data with the difference. ...
    (microsoft.public.dotnet.faqs)
  • RE: VB using XML
    ... the create the xml file, have all your records in an ado recordset then save it ... oRS.Save filepath, adPersistXML ...
    (microsoft.public.vb.database.ado)
  • Re: Error with reponse.write
    ... I can't help without knowing what's in the recordset. ... an xml file and post the contents of the xml file in your reply to this ... >> a quicker response by posting to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Ordering Columns in Drillthrough
    ... I have a XML file ... >drillthru with the ordering. ... >my own recordset from the recordset created when you do ... >>other information pertaining to an order, ...
    (microsoft.public.sqlserver.olap)
  • Load XMLDMO into recordset for PJGrid.ocx
    ... It can be bound to a ADO recordset. ... want to load a Project XML file into the recordset and then bind the grid to ... Here's a snippet that loads the xml file into a DOMDocument ... then how do I get a Project xml file into a recordset? ...
    (microsoft.public.project.vba)