Text limitation when exporting to Excel?

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
 
J

Joe Fallon

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

docmd.TransferSpreadsheet 7
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Exporting bunch of data to Excel 1
Access 2000 Export truncates to Excel 97-2000 1
Exporting data to Excel? 1
Can I stop access truncating >255char fields in export to excel? 5
How do I exceed 255 char limit when exporting calc'd field to .txt 2
Export and Analyze With error 1

Top