Text limitation when exporting to Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
If you use Analyze WIth Excel feature then data is truncated.
Try using code - TransferSpreadsheet.
 
Back
Top