exporting sql query defined

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Exporting a SQL query defined in code to Excel | Access forum

Exporting a SQL query defined in code to Excel | Access forum

resolvedResolved · Low Priority · Version 2003

Kristin has attended:
Access Advanced course
Access VBA course

Exporting a SQL query defined in code to Excel

I have a database with various combo boxes that enable the user to filter out data and build their own query. On the click of a search button, the strSQL is displayed as the recordsource of a listbox. I want to export the listbox's recordsource to Excel. How can I do that?

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips


Server loaded in 0.08 secs.