Export to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Create a query that gathers the data as needed.
Right Click on the query name and choose Export...
 
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
 
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.
 
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...
 
Back
Top