How to maintain text characters when converting from xls to dbf f.

G

Guest

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?
 
C

Cindy Winegarden

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

short character limit when creating database 1
Text in Text-formatted cells changes to ### after the 255th charac 2
How to fish out data from .fpt / .cdx files (Foxpro?) 4
Saving text with commas in a .csv file then converting to a .txt f 3
How to maintain row & column formatting when copying to a new work 1
Text Formatted Columns show as XXXXXXX 2
Excel converts 9-digit string to sci. not. when saved as csv 1
Problem with macro to email xls 5

Top