I need to export a Access recordsetclone to an Excel file.

  • Thread starter Thread starter Mark McLaren
  • Start date Start date
M

Mark McLaren

I would like to export access data populating a form that reflects filtering
that has been done on the form. I found that Docmd.Transferspreadsheet does
not accept recordsets as the information to export.
 
Right, but you can construct a parameter query that filters based on
selections made in your form and use that to do the export.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Query Name 1
Export to Excel - Access 2013 to Excel 2013 0
Using Forms to Export Data from an Access Table to an Excel Spreadsheet 1
export to excel from filtered datasheet 2
Export filtered records 2
Exporting from Access 2000 to Excel via script 2
two questions on exporting from a form 3
complete query before transferspreadsheet; only header row displayed 3

Back
Top