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