Data export coding

[deepaksharma]

Hii all experts,

I want to create a data export button on the form, on which when the user clicks, he can directly export the data set in a query to Excel and open the Excel file on the form. What code can I get for this?

[xps35]

Use DoCmd.TransferSpreadsheet

[deepaksharma]

in this code where i use the name of report...?

[Welshgasman]

Are you incapable of Googling for at least some information?
Microsoft have gone to a lot of trouble to document their products. At least give them a look from time to time.

https://learn.microsoft.com/en-us/of...ferspreadsheet

[deepaksharma]

Are you incapable of Googling for at least some information?
Microsoft have gone to a lot of trouble to document their products. At least give them a look from time to time.

https://learn.microsoft.com/en-us/of...ferspreadsheet

I have come here after working hard not only on Google but also on YouTube.

[Welshgasman]

So you have been given a command to use, but cannot find it on google.?

A simple expression "export access query to excel vba" would give you many links with examples.
I am not being cruel here, just trying to get you to learn things for yourself.
https://www.google.com/search?q=expo...e-gws-wiz-serp

[mike60smart]

Hi

You can use the following guide to setup a Command Button to run the Export.

[orange]

Richard Rost currently has a youtube video
Automated Export of Data from Microsoft Access to Excel with Just One Click