[AccessD] ADO Save recordset format adPersistADTG

Gustav Brock Gustav at cactus.dk
Thu Jun 15 11:51:34 CDT 2006


Hi all

The one finesse with this technique is that you can read (only) a data file of this format directly off a web server, manipulate it, and (optionally) save it locally:

  Set rst = New ADODB.Recordset
  strCnn = "PROVIDER=MSPersist;"
  strUrl = "http://www.example.com/pub/files/yourdata.xml"
  strFile = "d:\data\yourdata.xml"
  With rst
    .CursorLocation = adUseClient
    .LockType = adLockReadOnly
    .Open strUrl, strCnn, , , adCmdFile
    
    While Not .EOF = True
      Debug.Print "ID: ", !ID.Value
      .MoveNext
    Wend
    lngRec = .RecordCount
    
    .Save strFile, adPersistXML
    .Close
  End With

/gustav

>>> Gustav at cactus.dk 14-06-2006 20:12:52 >>>
Hi all

With ADO you can save a recordset to a file, normally an XML file, but another format, Microsoft Advanced Data TableGram, exists:

  rst.Save "d:\temp\records.dat", adPersistADTG

Where or why could this binary format be used? 
It creates file sizes about 1/3 of the XML file created if adPersistXML had been used.
Is it just a proprietary format for storing and retrieval of data to/from a single external file?

/gustav




More information about the AccessD mailing list