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?
 
Top