Make Table from Crosstab query

[stonesmith]

Is there a way to make a table from a crosstab query?
I need to export the results of a crosstab query in Excel format in an auto_run macro.

The DoCmd.TransferSpreadsheet acExport,
only accepts a table name and not a query, so I need to make a table.
Or is there another way to do this?

 

[Norie]

The DoCmd.TransferSpreadsheet acExport,
only accepts a table name and not a query, so I need to make a table.

No it doesn't.

Try it with your query name.