Access to Excel 255 character limit

  • Thread starter Thread starter Guest
  • Start date Start date
Use TransferSpreadsheet action in a macro or VBA code. Specify the most
recent version of EXCEL in the argument that allows you to define which
EXCEL version to be used.

Information about it is in Help files.
 
Thanks, but I still only get 255 characters in the excel document using Excel
8-10.
What am i missing?
 
Are you exporting a query or a table? If a query, are you sorting or
aggregating on that memo field?
 
Ken said:
If a query, are you sorting or
aggregating on that memo field?
Click to expand...

Ken,
I tried to put this one to rest a few weeks ago. For details, search
for the exact phrase "Suspected causes of truncation of Memo".

In summary:

The following can cause truncation:
GROUP BY
UNION (rather than UNION ALL)

The following do not or cannot cause truncation:
UNION ALL
DISTINCT
DISTINCTROW
ORDER BY
Set functions ('aggregate functions') e.g. MAX

The above was tested using Jet 4.0 (Access2000). If you have any test
cases that add to or contradict the above (e.g. for other versions of
MS Access), please post here or to the original thread.
Many thanks,
Jamie.

--
 
Back
Top