Exporting subform data using record source(not a named query)

[Cfox4]

Hello all,
I have looked at all of the methods (output to, transfer spreadsheet,
transfer text...) it appears to me that they all require a 'named' object
either table or query. The issue for me is that I do not use a named query
for the record source of my subform. I build the SQL string in code
depending on what fields the user populates as criteria on the main form.

Any suggestions on how to export to excel without using a named query? I'm
using Access 2003.
Thanks for your input.

 

[pietlinden]

Hello all,
I have looked at all of the methods (output to, transfer spreadsheet,
transfer text...) it appears to me that they all require a 'named' object
either table or query. The issue for me is that I do not use a named query
for the record source of my subform. I build the SQL string in code
depending on what fields the user populates as criteria on the main form.

Any suggestions on how to export to excel without using a named query? I'm
using Access 2003.
Thanks for your input.

use RecordsetClone and then pass that to CopyFromRecordset at
AccessWeb?