Hi all!

I run a query in Access 2003 and save the results as an Excel file. There
is one field in the Access table that is a MEMO field. Depending on how much
information is in the MEMO field I may or may not see all of that information
in the Excel file.

How can I see the entire contents of the MEMO fields in Excel?

Thanks in advance for your help!

How are you exporting the query? If you're using File | Export process, that
will truncate. Use TransferSpreadsheet action in a macro or in VBA code
instead.

What is the SQL statement of the query? If you're using a GROUP BY clause
with the memo field, or you use a union query with UNION (instead of UNION
ALL), the memo field will be truncated.

Or if you're using a calculated field in the query (even if it's not on the
memo field), you'll get truncation. See these Knowledge Base articles for
info:

Exported Query Expression Truncated at 255 Characters
http://support.microsoft.com/default...b;en-us;207668

Exported Query Expression Truncated at 255 Characters
http://support.microsoft.com/default...b;en-us;178743


Workaround would be to create a temporary table for the data, append the
query to the temporary table, export the table, and then delete the
temporary table (or delete the records from the temporary table so that you
can reuse the table the next time).
--

Ken Snell
<MS ACCESS MVP>


--

Ken Snell
<MS ACCESS MVP>

"diofan56" <(E-Mail Removed)> wrote in message
news:AA4EE88A-145B-4030-9212-(E-Mail Removed)...
> Hi all!
>
> I run a query in Access 2003 and save the results as an Excel file. There
> is one field in the Access table that is a MEMO field. Depending on how
> much
> information is in the MEMO field I may or may not see all of that
> information
> in the Excel file.
>
> How can I see the entire contents of the MEMO fields in Excel?
>
> Thanks in advance for your help!

diofan56 wrote:
> Hi all!
>
> I run a query in Access 2003 and save the results as an Excel file.
> There is one field in the Access table that is a MEMO field.
> Depending on how much information is in the MEMO field I may or may
> not see all of that information in the Excel file.
>
> How can I see the entire contents of the MEMO fields in Excel?
>
> Thanks in advance for your help!

How much can it show. Memo fields can be very large, but I believe
there is a 255 character limit on an Excel cell.

--
Joseph Meehan

Dia duit

"Joseph Meehan" <(E-Mail Removed)> wrote in message
news:PmsKf.161470$(E-Mail Removed)...
> diofan56 wrote:
>
> How much can it show. Memo fields can be very large, but I believe
> there is a 255 character limit on an Excel cell.

Joseph -

An EXCEL cell is limited to 255 characters only if its format is set to Text
(if you put in more than 255 characters in this situation, you'll just see #
characters in the cell).

If the format is General, it'll hold more than 65000 characters; however,
only about 1300 will display within the cell when viewing the spreadsheet;
but you can see the rest if you click in the cell and have the "formula bar"
visible.
--

Ken Snell
<MS ACCESS MVP>

Ken Snell (MVP) wrote:
> "Joseph Meehan" <(E-Mail Removed)> wrote in message
> news:PmsKf.161470$(E-Mail Removed)...
>> diofan56 wrote:
>>
>> How much can it show. Memo fields can be very large, but I
>> believe there is a 255 character limit on an Excel cell.
>
> Joseph -
>
> An EXCEL cell is limited to 255 characters only if its format is set
> to Text (if you put in more than 255 characters in this situation,
> you'll just see # characters in the cell).
>
> If the format is General, it'll hold more than 65000 characters;
> however, only about 1300 will display within the cell when viewing
> the spreadsheet; but you can see the rest if you click in the cell
> and have the "formula bar" visible.

Thanks for the info. I will try to remember that.

--
Joseph Meehan

Dia duit

Thanks again for the replies! THey are greatly appreciated!

The query I use is a simple query. There are no UNIONs or VBA code or
anything like that. What I am doing is reporting the information to
supervisors. When I run the Query I go to the File menu, Send To, Mail
Recipient (as Attachment), and I select Excel 97 - 2003. The results of the
'conversion' are placed into a Lotus Notes email. At that point I edit the
spreadsheet to make sure all information is being shown. This is where I
notice the truncation.

Dave
================

"diofan56" wrote:

> Hi all!
>
> I run a query in Access 2003 and save the results as an Excel file. There
> is one field in the Access table that is a MEMO field. Depending on how much
> information is in the MEMO field I may or may not see all of that information
> in the Excel file.
>
> How can I see the entire contents of the MEMO fields in Excel?
>
> Thanks in advance for your help!

The Send To item on the menu will cause truncation because it's based on
EXCEL 95 format (which does not support more than 255 characters in a
string). You need to use TransferSpreadsheet method, as noted earlier. See
the Help file for info about it.
--

Ken Snell
<MS ACCESS MVP>


"diofan56" <(E-Mail Removed)> wrote in message
news:8493530B-D067-4A66-8039-(E-Mail Removed)...
> Thanks again for the replies! THey are greatly appreciated!
>
> The query I use is a simple query. There are no UNIONs or VBA code or
> anything like that. What I am doing is reporting the information to
> supervisors. When I run the Query I go to the File menu, Send To, Mail
> Recipient (as Attachment), and I select Excel 97 - 2003. The results of
> the
> 'conversion' are placed into a Lotus Notes email. At that point I edit
> the
> spreadsheet to make sure all information is being shown. This is where I
> notice the truncation.
>
> Dave
> ================
>
> "diofan56" wrote:
>
>> Hi all!
>>
>> I run a query in Access 2003 and save the results as an Excel file.
>> There
>> is one field in the Access table that is a MEMO field. Depending on how
>> much
>> information is in the MEMO field I may or may not see all of that
>> information
>> in the Excel file.
>>
>> How can I see the entire contents of the MEMO fields in Excel?
>>
>> Thanks in advance for your help!