ExcelBanter - How do I prevent data truncation from access to excel using MS Qu.

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I prevent data truncation from access to excel using MS Qu. (https://www.excelbanter.com/excel-worksheet-functions/16478-how-do-i-prevent-data-truncation-access-excel-using-ms-qu.html)

ktw_jax1

How do I prevent data truncation from access to excel using MS Qu.

I am using Access and MS Query to move data from Access to Excel. Some of
the fields are Memo or greater than 255 characters. Whenever I refresh,
these fields are being truncated. Is there any way to prevent this?

no
-----Original Message-----
I am using Access and MS Query to move data from Access
to Excel. Some of
the fields are Memo or greater than 255 characters.
Whenever I refresh,
these fields are being truncated. Is there any way to
prevent this?
.

All times are GMT +1. The time now is 12:02 AM.