TransferSpreadsheet with MSDE

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