Exporting a Query into Excel

[ortizimo]

I'm trying to export a query into excel...this is what I'm using but its not working...any help is appreciated.



Private Sub Command573_Click()
DoCmd.OutputTo acOutputQuery, acFormatXLSX, "C:\retrogamesDB\Exports\Backup.xlsx", True, ""
End Sub

[pbaldy]

You're missing the name of the query. Check the arguments of OutputTo.

[ortizimo]

You're missing the name of the query. Check the arguments of OutputTo.

where does it go?

[pbaldy]

https://msdn.microsoft.com/en-us/vba...-method-access