Export a memo field to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am exporting query results to excel and everything works fine. My problem
is that I have a memo field that only exports part of the entry (like the
first two lines). I am not sure if there is a limit to the field. Is there
a way to export the whole entry?
 
Not really. A cell in Excel is limited to 255 characters. An Access Memo
field has a maximum of 64K. You will never get the entire memo field into an
Excel cell if it is over the 255 limit.

You can do it, but it would take some coding to break the memo into pieces
that will fit into a cell and write them to a temporary table and export that.
 
It isn't even exporting the 255 (that would be plenty). I was thinking I
needed a template in Excel with that particular column set up as a text file
but I am not sure if it is an Excel issue or an Access issue.
 
Back
Top