[AccessD] TrasnferSpreadsheet failing

Darryl Collins Darryl.Collins at coles.com.au
Tue Mar 17 22:44:23 CDT 2009


There are also all sorts of user created issues. A common problem is you only need one entry (cell) in Excel (out of thousands of records) to contain data that Access is not prepared to handle (say text when an integer is expected) and the whole thing fails.  I much rather validate all the data first, and the pass it to Access - usually line by line, just dropping and recording those that fail for the user to correct and try again.  It is a bit slower, but you can be much more confident of reliablity.

I always go for risk control over speed.  There is no point in getting the wrong answer really fast.

cheers
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 2:37 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

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





More information about the AccessD mailing list