ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Importing data from Access into Excel: prob w/ cutting off fields (https://www.excelbanter.com/excel-worksheet-functions/11936-importing-data-access-into-excel-prob-w-cutting-off-fields.html)

Nicole L.

Importing data from Access into Excel: prob w/ cutting off fields
 
When I export data from a report in Access into a new Excel worksheet, it
cuts off the text in some of the longer fields. Why is it doing that? It's
not exporting over the full data.

Any ideas as to why or how to fix?

It's not a wrapping issue, it's not a limitation to character numbers; what
could it be?

Nicole L.

I found some answers...
http://office.microsoft.com/en-us/as...448581033.aspx


"Nicole L." wrote:

When I export data from a report in Access into a new Excel worksheet, it
cuts off the text in some of the longer fields. Why is it doing that? It's
not exporting over the full data.

Any ideas as to why or how to fix?

It's not a wrapping issue, it's not a limitation to character numbers; what
could it be?



All times are GMT +1. The time now is 03:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com