Export to Excel

M

microsoft

Hi

I have created a database which captures all trades performed by the
Investment Team on a daily basis. All the necessary tables, forms, queries
and reports have been created.

I wish to export data displayed into a report into an excel document (not
all the fields in this report needs to be exported). Also I wish to select
the order in which the fields are exported.

Is this possible and if so how.

Thanks
 
M

[MVP] S.Clark

Create a query that gathers the data as needed.
Right Click on the query name and choose Export...
 
M

microsoft

Hi

Thanks for your help thus far, and based on your instructions I was able to
create a query and extract just the data I needed to Excel.

I wish to make this process more user friendly for the user, therefore I
would like a form where once the user clicks on the export button the data
from the query is extracted. However when trying to achieve the export
process requires that the data be pulled from a report.

How can I achieve my goal

Thanks
 
M

[MVP] S.Clark

The TransferSpreadsheet macro action (or DoCmd method) can be used to
automate the export process, but only for data(table/query).

The OutputTo Action allows for sending a report to Excel.

Create a form, add a command button, and code to execute OutputTo.
 
M

microsoft

thanks got it figured out.

[MVP] S.Clark said:
The TransferSpreadsheet macro action (or DoCmd method) can be used to
automate the export process, but only for data(table/query).

The OutputTo Action allows for sending a report to Excel.

Create a form, add a command button, and code to execute OutputTo.
Click to expand...
 
Top