Re: Saving DAO recordset

I'm a little rusty on what you can and can't do with DAO recordsets,
but I'm pretty sure that what you are trying is a dead end. I'd ask on
one of the Access newsgroups and see what they have to say.

--Mary

On Thu, 30 Nov 2006 16:30:01 -0800, Saumil
<Saumil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi,
I am wanting to save DAO recordset as an Excel Workbook but I can't find a
way to do so. Please have a look on following code.
Public Sub paramparse()
Dim qdf As QueryDef
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set qdf = db.QueryDefs("param_qry") 'pram_qry is stored query
qdf.Parameters("dbplace") = "amas" 'dbplace is a parsing field of query
Set rs = qdf.OpenRecordset()
End Sub

the recordset is ready in rs after "Set rs = qdf.Openrecordset() "statement
but it isn't possible to save this recordset as how we can save when it is
ADO recordset. Also, I can't use "Set rs = qdf.OpenRecordset()" statement if
I declare all objects as ADO objects. So would anybody please help me showing
how to save DAO recordsets??
Thanks
Saumil
.

Relevant Pages

  • Re: syntax on ADODB recordset
    ... Dim rstClone As ADODB.Recordset ... Do you know that the recordset of frmActive is an ADODB recordset? ... Recordset and its RecordsetClone will both be DAO recordsets, ...
    (microsoft.public.access.formscoding)
  • Re: access 2003
    ... Dim ctl As Control ... Dim rs As Recordset ... This sets the query definitions for choosing data to create an invoice using ... Event on combo box: Private Sub ChooseCust_AfterUpdate ...
    (microsoft.public.access.conversion)
  • Re: A simple problem with MoveFirst
    ... update the table (rather than using the recordset) means that from ADO's ... Dim tbDataToBeEmailed As ADODB.Recordset ... tbDataToBeEmailed.Open "tbDataToBeEmailed", cnCurrent, adOpenKeyset, ... "You have not entered time into the ACIS ...
    (microsoft.public.access.modulesdaovba)
  • Re: macro error due to editor
    ... Your VBA code never sets DB or the Recordset variables to Nothing. ... Do you declare DB as a global variable anywhere in the database file (e.g., ... EmpDateAs String ... Dim DB As Database, Qry As QueryDef, Qry_def As String ...
    (microsoft.public.access.macros)
  • Re: DAO MUCH faster than ADO in this test
    ... DAO is well-known to be faster than ADO. ... Of course the DAO loop ran faster than the SQL loop; ... advantage of a table-type recordset, which only works on local tables. ... Dim starttime As Single, finishtime As Single ...
    (microsoft.public.access.modulesdaovba)