[AccessD] TrasnferSpreadsheet failing

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Tue Mar 17 16:56:32 CDT 2009


Dear List:

 

I am trying to export data from a query to a spreadsheet.

I get the error 3027 Cannot update. Database or object is read only.

The line is: DoCmd.TransferSpreadsheet acExportDelim,
acSpreadsheetTypeExcel9, "qryExportMailingList", varFileName, True

varfilename has the full path, name and extension.  

 

Any ideas what I'm doing wrong?

 

MTIA

 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 

 


More information about the AccessD mailing list