Hi,

I have a very big Access database that I am trying to copy onto MS
Excel for analysis. However, when I try to export this data using the
"Analyze using Excel" function, or by copying all fields and pasting it
onto Excel, I find that some of the longer text entries (eg: Claim
details) get truncated.

Interestingly, if I go INTO that particular cell entry, select the text
in the cell, copy and paste it into an Excel cell, it does not get
truncated at all.

Can someone please help me with this? I would like to know:
1. Why this is happening
2. A possible way in which I can move all the data into Excel

I tried the "export" function, but this data is read-only, so that
function doesnt work.

Thanks in advance,

Joe.