button to export query?

[Jerome]

Hi,

I've got the following situation:

A user needs to export a certain real-time list of data from his Access
2003 database as an Excel file. I've got the query and I know how to
export the query manually. But I need to have a button that the user
simply has to click to get asked where he wants to save (fixed location
is okay too) his XLS file. The app is running in runtime mode.

Is that possible and how do I do that?

Thanks a lot!

Jerome

 

[Allen Browne]

You can use the TransferSpreadsheet action to export to Excel.

To let the user select a file name in the runtime, you need an API call.
This page has the code:
http://www.mvps.org/access/api/api0001.htm

 

[Jerome]

Thanks, I don't really need the 'select a file name' option. It can
simply be the name of the query or some other hard-coded name.

I'll looking into the TRansferSpreadsheet function!