HELP!! w/Exporting Access to Excel

U

UTAlum

I am running a query on information from a table. When I run the query I
want it to automatically export the information to a spreadsheet in Excel, so
that I can move around the rows of data into a different order (It is a query
for a schedule). I can't move the rows when they are in access. Is there a
way I can export this without copying and pasting or going through the steps
every time?
 
N

Nikos Yannacopoulos

Make a simple macro with a TransferSpreadsheet action, with the
following arguments:

Transfer Type: Export
Spreadsheet Type: the latest available in your version of Access (should
be the default)
Tale name: the name ofthe query you want to export (yes, it works with
queries)
File Name: full path and filename for exported workbook
Has field names: Yes
Range: leave blank

Run the macro, and it will do what you want, without requiring you to
open the query first.

HTH,
Nikos
 
Top