Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting Views to Excel Using Access

Status
Not open for further replies.

tstrike

Technical User
Jun 17, 2002
44
US
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.

 

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top