| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to maintain text characters when converting from xls to dbf f.
I am trying to save an xls (97-2002) file as a DBF IV format in order to use
it in ArcGIS. The dbf format trucates my text (in addition to the column heading) and converts the cell text format into a number format. Is there any way around this? Is there a maximum character length for DBF cells? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to maintain text characters when converting from xls to dbf f.
Hi Nombo,
I'm used to working with FoxPro DBFs which have a limit of 256 characters in a Character field (for longer strings use a Memo field) and a limit of 10 characters for field names. Maybe DBF IV is the same. -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP www.cindywinegarden.com "Nombo" wrote in message ... I am trying to save an xls (97-2002) file as a DBF IV format in order to use it in ArcGIS. The dbf format trucates my text (in addition to the column heading) and converts the cell text format into a number format. Is there any way around this? Is there a maximum character length for DBF cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display text 1024 characters in a cell | Excel Worksheet Functions | |||
| Excel Save As... text with special characters | Excel Discussion (Misc queries) | |||
| how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) | |||
| Converting Text to Number | Excel Discussion (Misc queries) | |||
| roundoff when converting text to numbers | Excel Worksheet Functions | |||
Linear Mode
