Text length when transferring into Excel

G

Guest

When copying/pasting or exporting an Access table into Excel, the longest
text fields are truncated in the Excel version after a set number (256
possibly) of characters. Excel cells definitely have capacity for
more--anybody have a workaround? TIA
 
K

Ken Snell \(MVP\)

Use TransferSpreadsheet action (macro or VBA code) to export long text
string data to EXCEL. Using File | Export process or using OutputTo will
result in truncation of long strings.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access 2002 truncates text when linking to Excel 2002 1
Importing Excel Data Into MS Access Memo Field 2
mailmerge maximum field size 2
Can I stop access truncating >255char fields in export to excel? 5
RDBMerge Text limit 0
Decimal Truncation on Export 2
255 Character Limit for Linked Excel data 1

Top