adodb.recordset.save and back

From: Peter Plumber (Klempner_at_gmxdot.net)
Date: 02/22/04 

Date: Sun, 22 Feb 2004 22:39:12 +0100

This is what I have:

    Dim cn As New ADODB.Connection
    Dim rs As New ADODB.Recordset

    cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=db1.mdb"
    cn.Open
    rs.Open "SELECT * FROM tblData", cn
    rs.Save "tblUser.xml", adPersistXML
    rs.Close
    cn.Close

and a very nice "tblUser.xml"-file with all the data from tblData

is there a fast way to get the data back from the xml-file into the table

thx

Peter

Relevant Pages

  • How to get Reference Counter for an Object?
    ... Dim x as clsMyClass, y as clsMyClass ... thx in advance ... Peter ...
    (microsoft.public.vb.general.discussion)
  • Re: VB 6.0 to Launch excel
    ... Jason V ... "Peter T" wrote: ... Dim xlapp As Excel.Application 'The Excel application object ...
    (microsoft.public.excel.programming)
  • 2 Table search...Output excel
    ... If 150 records exist in tblData, there will 150 results in Excel... ... Dim dbConnection As Data.OleDb.OleDbConnection ... Dim dbCommand As Data.OleDb.OleDbCommand ... Dim dbDataAdapter As Data.OleDb.OleDbDataAdapter ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: 2 Table search...Output excel
    ... If 150 records exist in tblData, there will 150 results in Excel... ... Dim dbConnection As Data.OleDb.OleDbConnection ... Dim dbCommand As Data.OleDb.OleDbCommand ... Dim dbDataAdapter As Data.OleDb.OleDbDataAdapter ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Re: Problem by sendig a fax
    ... Sorry Peter, I think I'm helpless here unless I can repro the problem ... But I don't have ASP expertise. ... > Dim A2kApp ... > - acting with the faxserver over an office component?? ...
    (microsoft.public.win2000.fax)