I ran a macro to output my datasheet to an excel spreadsheet and found that text data where truncated. All data were intact on the datasheet but truncated when exported to excel. I thing the problem lies in excel not able to accomodate long text. If copied manually I think should be able to solve the problem but I prefer to do it in macro.
I am running Office97 access/excel.