[AccessD] Exporting Memo Field

Bob,

 Here's a good listing (old, but still good) of all the in's and out's with
memo fields and truncation:

http://allenbrowne.com/ser-63.html

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
Sent: Sunday, January 19, 2014 11:05 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Exporting Memo Field

Hello to the Group,
I need to manipulate some text which in memo fields.
When I try to parse it in VBA, I seem only to be able to access the first
255 chars.

I thought that I had solved the problem by copying the whole table to Word.
I know this sounds funny, but it worked. It pasted into Word in the form of
a Word table. 

I thought that then it should easy to copy back into Access, or into Excel
and then into Access. The latter seemed to work. But when I started to
process the newly created table that I pasted into from Excel, I discovered
that again I only had the first 255 chars.

How can I "access" this data?

TIA,

Bob Heygood

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