Export to excel on button click

[Jim.H.]

Export to excel on button click:


How can I export a query result into excel on a button click?
Any example would be very helpful.

[June7]

Check out the TransportSpreadsheet method.

Review this
http://forums.aspfree.com/microsoft-...el-413629.html

[Access_Blaster]

Export to excel on button click:
How can I export a query result into excel on a button click?
Any example would be very helpful.

Create a new macro; in the "add new action" drop down choose export with formatting.

Oject type: query
Oject name: Your query
Output format: MicrosoftExcel(*.xls)
Etc...

That’s pretty much it, unless the output is huge. Then create your button, when the button wizard finishes choose miscellaneous >> run macro >> find your macro, and your done.

Richard