[AccessD] Exporting Memo Field

This kind of guruship does NOT grow on trees. OMG that was a good read,
thank you Jim for posting. I extra-specially appreciated learning:


The first SELECT in a UNION query defines the field type, so you can add
another UNION ALL using a Memo field so Access gets the idea. For example,
instead of:
    SELECT ID, F1 & F2 AS Result FROM Table1
    UNION ALL SELECT ID, F1 & F2 AS Result FROM Table2;
add a real memo field first (even though it returns no records), like this:
    SELECT ID, MyMemo FROM Table3 WHERE (False)
    UNION ALL SELECT ID, F1 & F2 AS Result FROM Table1
    UNION ALL SELECT ID, F1 & F2 AS Result FROM Table2;


On Mon, Jan 20, 2014 at 12:12 PM, Jim Dettman <jimdettman at verizon.net>wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
*Regards,*


*Bill Benson*
*VBACreations*

PS:  You've gotten this e-mail *because you matter to me!*