Export to Excell loses words

angellrp

Registered User.
Local time
Today, 20:54
Joined
Feb 26, 2003
Messages
18
When I export my database report to excel I lose any characters in cells which are over 255 characters. Please can anyone show me how to get around this?

Thanks
 
Excel 2003 with SP2
 
In the query that selects the data for the report for any fields which have more than 255 characters change this from "group by" to "first" and you should get all the text from the field.
 

Users who are viewing this thread

Back
Top Bottom