Export to Excel

[netadmin]

I have a form which displays analytical data. What I
would like is a command button that once pressed exports
the data on the form to an excel spreadsheet. What code
would I need to accomplish this task. Any help would be
appreciated.

 

[SFAxess]

There are the "OutputTo" and "TransferSpreadsheet"
methods of the Docmd object. Check out the help to see
which one suits your needs better. The syntax is outlined
in the help file as well.

 

[Jonathan Parminter]

Hi, just a thought... you can usually achieve the same
analysis in Access without having to export to excel. This
is especially true if the analysis is predictable. It
saves the hassle of formatting in excel and means an
untrained person can produce reports.

Luck
Jonathan