[AccessD] TrasnferSpreadsheet failing

Max:

Leaving out the spreadsheet type also worked.  Go figure.  What a mysterious
language. 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Tuesday, March 17, 2009 5:17 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com