Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Thu May 4 07:42:41 CDT 2006
I just modified my query to left([Cast[;1024) But when dooing this I get this strange id at the end (identifier?) of my text in Excel. "Doug Aguirre, Rob Armstrong, Michael Arthur, Maria Bello, Jon Bernthal, Robert Blanche, Lucia Brawley, Kurt Caceres, Nicolas Cage, Francesca Casale, Jude Ciccolella, Lori M. Cincotta, Dara Coleman, Nick Damici, Patti D'Arbanville, Stephen Dorff, Thomas F.-21-1935655697-343818398-725345543-1132" Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps - IT Helps Sent: Thursday, May 04, 2006 1:32 PM To: Access Developers discussion and problem solving Subject: [AccessD] Copyrcordset to Excel fails on lenthy memo field. When having a long memofield and using copyrecordset to excel then call fails when having lengthy texts in the memofield. I'm not sure of the maximum length but in this case the text is 1102 karakters long. 480 characters seems to pass. When using copy/paste the excel cell can accept this 1102 long tekst, os its not a cell text limitation, but I supose a DAO or Excel object limitation? Is there a simple workaround still using the copyrecordset function? The only simple solution I see is to truncate my memofield to the maximum length (which I don't know) but this i want to avoid. It's not that a big deal because is the cast list from a movie, so an actor in the +1000 character is probably not that important. In this case it's the cast for the "World Trade Center" Movie! To sumerize my questions: Simple way to copy long memofields to excel using copyrecordset? and/or Whats the maximum fieldlength I can copyrecordset tot excel? greetings Erwin Craps Zaakvoerder www.ithelps.be/onsgezin This E-mail is confidential, may be legally privileged, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offence. Please delete if obtained in error and E-mail confirmation to the sender. IT Helps - I.T. Help Center *** Box Office Belgium & Luxembourg www.ithelps.be <http://www.ithelps.be/> * www.boxoffice.be <http://www.boxoffice.be/> * www.stadleuven.be <http://www.stadleuven.be/> IT Helps bvba* ** Mercatorpad 3 ** 3000 Leuven IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 E-mail: Info at ithelps.be Box Office ** Fax: +32 16 296 406 ** Box Office E-mail: Staff at boxoffice.be <mailto:figures at boxoffice.be> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com