export to excel

[Guest]

If I have a make table query, I want to create a macro to transfer the
spreadsheet to excel, so I do open query, transfer spreadsheet. Is this the
correct steps and also I am getting confused as to where to type the path
where I want it saved.

Thanks,

 

[Guest]

hi,
this is one correct way. there are other ways that work and they too are
correct.
If it don't work, then that is the wrong way.
and as your are filling out the tranferspreadsheet in your macor, put the
file path in the file name box

regards
FSt1

 

[Guest]

Pam,

Do you need this information to be in a table? If not you can handle this
by just creating a design query as normal. Create a macro and in the action
section select "Output To"

Set the Action Arguments as follows:

Oject Type: Query
Oject Name: (the name of the query you want to run)
Output Format: Microsoft Excel (you have a number of versions available)
Output File: (The path you would like to save to (eg: C:\My Documents))
Auto Start: (yes or no)

all else blank.

regards,
Robert