Andy, Memo data seems to go in no problem with no restriction on field length. I just tried a memo field in excess of 1000 characters.
Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Davies Sent: 17 August 2007 10:56 To: [email protected] Subject: RE: Excel question > Using Jaime's method doesn't involve any export/import of physical > data files. > Dave Crozier Dave, does rs.Open("select * from credidt.dbf",...) do less under the hood than use credidt.dbf then? .. and does anyone know if the excel .CopyFromRecordset method also truncates cells to 256 characters? Andrew Davies MBCS CITP - AndyD 8-)# ********************************************************************** Manchester City Council supports Smokefree England - 1 July 2007 This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Please contact [EMAIL PROTECTED] with any queries. ********************************************************************** [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
