Export Query Question

R

Richard

Hi all,

If I open a database window and select "Queries†then scroll down to a query
called qContacts. Then right click on the query and select export, I change
the Save as type to: Microsoft Excel 97-2000 Its exactly what I need. How can
I reproduce this behind a command button?

Richard
 
P

PieterLinden via AccessMonster.com

Richard said:
Hi all,

If I open a database window and select "Queries†then scroll down to a query
called qContacts. Then right click on the query and select export, I change
the Save as type to: Microsoft Excel 97-2000 Its exactly what I need. How can
I reproduce this behind a command button?

Richard
Click to expand...

Use TransferSpreadsheet, and pass the query name as the object you want to
export. then call that in the Click event of your command button.
 
Top