Text length when transferring into Excel

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top