[AccessD] TrasnferSpreadsheet failing

Rocky,
Are you sure the destination is correct  and you can definatley write to it
and there is no existing file of the same name.

If so, with the acSpreadsheettype, just left it use the default and see what
happens.  ie,  just put a comma there and dont select a type of SS.

With the acexportdelim, this is for CSV try the other alternatives.

HTH
Max


2009/3/17 Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com>

> 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/>
>
>
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>