Access Export Problem

P

PowerLifter1450

Hi all, I have a memo field in a query (Access 2003 / WinXP) that I am
trying to export to Excel. When I do the export manually, it exports
the column fine, with nothing being truncated. However, when I use a
macro to do the export (Output To Excel 97-2003) the memo field gets
truncated. Any ideas why this is happening, and/or what I can do to
fix this? Thanks for any information!
 
K

Ken Snell \(MVP\)

OutputTo action uses EXCEL 95 format, which does not support text strings
longer than 255 characters. Use the TransferSpreadsheet action instead, and
specify the most recent version of EXCEL in the EXCEL format argument.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 2021 export question 0
Exporting Outlook 2007 contact list without losing groups 0
Export tracked changes to a new document 0
VBA concatenate ranges into a new document 0
Images are pixelated when saving to PDF 0
transfer to excel 1
Unreadable text when viewing organization chart in Web version of Visio 365 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0

Top