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.

--
 

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
255 Character Limit for Linked Excel data 1
Import Excel with more than 255 columns 1
EXPORT QUery with memo field to excel, truncated data 2
export access memo fileds to excel 2
Export Access Table with Memo Field to Excel 2
Avoid truncation 2
Import/export from access query to excel 2

Back
Top