Exporting Queries to Excel

[John Canavan]

I'm trying to export a select query to Excel by setting
up a macro with the TransferSpreadsheet function.

In the table name field I am typing in the name of the
query, however, I am unable to run this macro.

Doing the same process and exporting tables is a breeze,
but for some reason it doesn't work for exporting queries.

Please help!

 

[Piers 2k]

John,

Just tried this with a simple table and query, and it worked fine for me.
Are you getting the name of the query correct? Try renaming the query to
something simple with nospaces or underscores just to get it working.

These are the properties I just had:
Transfer Type ! Export (I missed changing this from Import the first time -
check it!)
Spreadsheet Type | Microsoft Excel 8-10
Table Name | TestQuery
File Name | File
Has field names | Yes
Range | <blank>
--

Hope this helps,

Piers

| I'm trying to export a select query to Excel by setting
| up a macro with the TransferSpreadsheet function.
|
| In the table name field I am typing in the name of the
| query, however, I am unable to run this macro.
|
| Doing the same process and exporting tables is a breeze,
| but for some reason it doesn't work for exporting queries.
|
| Please help!
|
|