Exporting Views to Excel Using Access

[tstrike]

I am trying to Export several veiws to Excel using Access. I tried Using DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "dbo.qryMNADLDSM", "c:\temp\MNADLExport.xls"
When I run the code, I get the following error:
Microsoft Office Access can't find the object 'dbo.qryMNADLDSM.'
I have tried removing the dbo beginning and also tried putting in exactly what I see in the querys tab, but nether seems to work. Any suggestions on how to make this work? I need it in excel for sending out to the audiance.

 

[JBaileys]

Two questions:

Is excel and access on the same machine? If not, can you try it?

Have you tried to set-up a pivot table in excel and connect to the query?

I would make sure there is connectivity.