| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
truncation of fields inported from access
How do I work around the 255 character truncation of text fields in excel. I
am exporting from access to excel and loosing text. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
truncation of fields inported from access
On Aug 18, 4:18 pm, liddleti
wrote: How do I work around the 255 character truncation of text fields in excel. I am exporting from access to excel and loosing text. Try formatting the cells as General. Versions as old as Excel 2000 can have far more characters than this in a cell, but you may need to change out of Text format, I forget exactly how this works. Excel 2007 is unlimited or something like that, if upgrading is an option. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query of an Access database won't let me get more than 95 fields. | Excel Discussion (Misc queries) | |||
| Missing fields when I import from Access to Excel... | New Users to Excel | |||
| Exporting fields from access to excel | Excel Discussion (Misc queries) | |||
| Grid on inported Artwork | Excel Discussion (Misc queries) | |||
| How do I prevent data truncation from access to excel using MS Qu. | Excel Worksheet Functions | |||
Linear Mode
