Access to Excel 255 character limit

B

Brent_Fanguy

How do i export from access to excel a field that is greater than 255
characters.
 
K

Ken Snell [MVP]

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.
 
B

Brent_Fanguy

Thanks, but I still only get 255 characters in the excel document using Excel
8-10.
What am i missing?
 
K

Ken Snell [MVP]

Are you exporting a query or a table? If a query, are you sorting or
aggregating on that memo field?
 

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

Import Excel with more than 255 columns 1
EXPORT QUery with memo field to excel, truncated data 2
export access memo fileds to excel 1
Mail Merge with Excel and Word 2007 1
255 Character Limit for Linked Excel data 1
vlookup character limitations 1
Outlook 365 overriding formatting choices 0
Default local file location - folder redirection slowness 0

Top