ExcelBanter - Truncated Exported Data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Truncated Exported Data (https://www.excelbanter.com/excel-discussion-misc-queries/81600-truncated-exported-data.html)

baconroll

Truncated Exported Data

I have a query in MSAccess which I export to Excel as a formatted spreadsheet.

For some reason, it is truncating the data when it goes into excel, yet when
I export the same data without saving it as formatted, this does not happen.

any ideas please?
thanks

All times are GMT +1. The time now is 03:14 PM.