OutputTo truncates memo field?

[Guest]

I'm working in Access 2003 trying to use OutputTo to export to Excel. I
cannot use TransferSpreadsheet due to limitations of this function. I
thought the truncation issue of a memo was corrected and it seems to work
fine from the Access user environment, but when I attempt to perform the same
process via OutputTo my memo field is truncated. Am I using an incorrect
parameter or is this still a problem? Thanks.

 

[privatenews]

Hello Lisa,

Thank you for your post in MSDN newsgroup!

I understand that you still encountered truncation issue of a memo fields
when you use outputto instead of transferSpreadsheet to export database to
Excel.

Based on my scope, OutputTo (macro or VBA) and File Export to Excel 97-2003
format(with "Save formatted" selected)still truncate while
TransferSpreadsheet and File Export (with "Save formatted" deselected) do
not truncate.

The behavior of Outputto function was actually discussed internally when
changing the behavior of File Export to Excel in Access 2002. The
limitation of this truncation is because that is/was old version Excel’s
maximum for a given cell. Product team agrees to keep this code untouched
and recommend to use TransferSpreadsheet function instead. Will you let's
know the details of limitation that you cannot use the function so that we
may find some workaround?

More related information:


294286 Memo field is truncated when you output a report to excel in Access
2002
http://support.microsoft.com/?id=294286

Exported Query Expression Truncated at 255 Characters
http://support.microsoft.com/default.aspx?scid=kb;en-us;207668

Exported Query Expression Truncated at 255 Characters
http://support.microsoft.com/default.aspx?scid=kb;en-us;178743


If you have any update or questions on this, please feel free to post back.
I look forward to your reply.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.