Text limitation when exporting to Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mauricio Silva - 05 Jul 2005 20:13 GMT

I am trying to export some of my data to Excel, but some of my text are being
cut at 255th char. The thing is: if I go to Excel I can put more than 255
char in one cell. Why can't I do it from Access? Is there a way?

Using: MS Access 2000, Excel 2000

Thank you very much for any assitance

Mauricio Silva

Reply to this Message

Joe Fallon - 07 Jul 2005 01:17 GMT

If you use Analyze WIth Excel feature then data is truncated.
Try using code - TransferSpreadsheet.

Signature

Joe Fallon
Access MVP

>I am trying to export some of my data to Excel, but some of my text are
>being
[quoted text clipped - 6 lines]
>
> Mauricio Silva

Reply to this Message