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.