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.
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.