255 character truncation when copy/pasting a Data View from Access to Excel
<p>I've seen some stuff online about exporting data, but what I'm doing is a Copy/Paste.  I'm looking at a Datasheet View of an Access form, and I'm trying to copy it to Excel.  The form has 2 Memo fields.  </p>

<p>If I copy the Memo fields one at a time, I get all the contents of the field.  If I try to copy the whole Datasheet View and paste it into Excel, the Memo fields get truncated.</p>

<p>Is there a way around this, other than exporting the data?</p>