exporting a report to excel but chopping memo size down

[secondangel]

Hi there i have a report which is based on a table.

In the table several are of type 'memo'

When i export to excel it seems to chop down the amount of characters.

Anybody know why this happens and a workaround.

I tried exporting to text but it doesnt hold the formatting i need. When i export to csv its nicely within each cell properly.

Is it down to the size of data per cell in excel ?
The data is fully there in teh report - print view etc.

I use access 2003

Thanks for any help

 

[secondangel]

its fine i found that exporting the table using a macro running transferspreadsheet set to excel 8-10 doesnt truncate the memo fields.

however if you set it to c:\documents and settings\User1\desktop\file1.xls

you get an error

set it to c:\file1.xls

it works fine and exports without truncating.


just thought id share my solution