Access macro to save query form output

[sroy]

I am looking for a Access macro to save query form output through a button. Thanks in advance.

[June7]

What do you mean by 'save query form output'? The data is already in table. Do you want to open a report or export the data?

[sroy]

I want to export the data through a button.
The data in table is query form output. Hope this is clear.

[June7]

Export to where? Excel? PDF? Word? CSV?

There are several ways to accomplish.

Use the Import/Export wizard.

Report open in PrintPreview, right click on the report > Export > choose.

Use code (macro or VBA) with TranferSpreadsheet or OutPutTo methods.

Other options involve advanced VBA code.

[sroy]

Export to Excel. I need a VBA button to accomplish this task.

[June7]

Explore the referenced methods. There are many examples available. Google or search this forum.