Excel XP: any way to beat the 255 character limit?

[Wizdar]

I have data stored in Access in memo fields that will be presented in Excel tables. When I export the query data, the resulting table data stops at 255 characters. It’s too much trouble to create a report in Access.

Any way to beat this ancient problem?

 

[BlueHorizon]

Hi,
Excel allows 32,767 characters total in each cell. Only 1,024 display in the cell itself, but all 32,767 display in the formula bar. I may not understand the question....

Best,
BlueHorizon

 

[jh3016]

Try looking at this thread.

http://www.tek-tips.com/faqs.cfm?spid=703&sfid=2473

 

[combo]

Hi,
try to export table/qurey to higher version of excel using macro:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Tabelel5", "C:\T5.xls", True
this works for me.
BTW, excel is inconsistent with the cell limit. You can have more than 255 characters in one cell. They will be copied within the same instance of excel, when you try to copy between two instances, copied data is truncated.

combo