TransferSpreadsheet with MSDE view

  • Thread starter Austin Streetman via AccessMonster.com
  • Start date
A

Austin Streetman via AccessMonster.com

I am using TransferSpreadsheet in an Access project that is connected to a
MSDE SQL database. I can export tables just fine, but it says ?Database
can?t find the object ?myQueryname? when I try to export a View or a Stored
Procedure.

theQueryName = " myQueryname? "

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
theQueryName, theExcelPath, True

Thanks for any help!
 
Top