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