Import from Access to Excel cuts off some text

[TyeReece]

I have tried to import some data from Access to Excel and the text in the larger fields are being cut off. How do I fix this?

 

[Joe4]

Are these Memo fields greater than 255 characters?
See here: http://support.microsoft.com/kb/294286

 

[TyeReece]

they are memo fields, some of which are greater than 255

 

[Joe4]

they are memo fields, some of which are greater than 255

Then take a look at that link I provided, which explains the problems and tell you how to work around it.

 

[TyeReece]

Thanks!