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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

use RecordsetClone and then pass that to CopyFromRecordset at
AccessWeb?
 
Back
Top