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

Top