[AccessD] TrasnferSpreadsheet failing

Have to agree.  Especially if you need formulas or formatting - anything
more than a flat file. 


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 Darryl Collins
Sent: Tuesday, March 17, 2009 8:34 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] TrasnferSpreadsheet failing

Hi Rocky,

Personally I find the TransferSpreadsheet to be far too unreliable for
everyday use.  I much prefer pulling down the data using the recordset
method. - just my experience.

regards
Darryl

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Wednesday, 18 March 2009 8:57 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] TrasnferSpreadsheet failing


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/>







This email and any attachments may contain privileged and confidential
information and are intended for the named addressee only. If you have
received this e-mail in error, please notify the sender and delete this
e-mail immediately. Any confidentiality, privilege or copyright is not
waived or lost because this e-mail has been sent to you in error. It is your
responsibility to check this e-mail and any attachments for viruses.  No
warranty is made that this material is free from computer virus or any other
defect or error.  Any loss/damage incurred by using this material is not the
sender's responsibility.  The sender's entire liability will be limited to
resupplying the material.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com