[AccessD] Exporting Memo Field

How about writing to a textstream object using scripting.filesystemobject
On Jan 19, 2014 11:06 PM, "Bob Heygood" <accesspro at gmail.com> wrote:

> 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
>