Exporting to Excel from Crosstab query..

[bicit]

Hi All,
is there a good method for exporting to an Excel file based on a crosstab query? I can use the Pivottable view to manually extract data but I need to be able to automate this from within the app..
thanks,
Mike

 

[dhookom]

Have you looked at the transferSpreadsheet command?

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[bicit]

Hi Duane,
thanks, I know that will work with a query, but at the risk of sounding lazy I was hoping to be able to export from a report that's already formatted. Appreciate the quick reply.
Mike

 

[PHV]

Take a look at the DoCmd.OutputTo method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bicit]

Thanks PH..I've tried that, for some reason creating a blank 4K Excel file..no data whatsoever.
Mike