Export Query To SQL Server

[Juan4412]

I have tried this syntax

DoCmd.TransferSpreadsheet acOutputQuery, acSpreadsheetTypeExcel12, "QueryName", "C:\Test\QueryExport.xlsx", True

However, I get an error of
Run-time error '3323':
The query can not be used as a row source

This is a simple select query, and I just want to write the result to Excel.

[aytee111]

acOutputQuery should be acExport.

Am wondering why your subject line mentions SQL Server?

[Juan4412]

Good catch - to much on my mind this morning.

If I change it to acExport I get the same error.

[aytee111]

Do it manually from the nav pane to test (a) exporting the query and (b) writing to that folder. Then you will be able to narrow down the problem.

[Juan4412]

You are over my head on that one....
How would I do this?

[aytee111]

Go to the nav pane, the place where it has the list of queries. Right-click on the query that you are trying to export, click export/Excel. Copy and paste or browse to that location you have specified.

[Juan4412]

Write permissions to the directory was the problem. Thank you for walking me through it

[aytee111]

You're welcome!