Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I am having some problems loading a dbf file into excel 2007. If properly imported it would have 4642 rows and extend to column ASK. If I just open it, it truncates the dbf at column IU, which is the same as excel 2003. If I get external data/from text, after about 10 minutes it hasn't loaded.

    Any suggestions on loading a dbf file of this size?
    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Excel treats .dbf files as DBase files. A DBase file can have a maximum of 255 fields (columns), so it's not surprising that the import stops at column IU (the 255th column).

    If Arcgis uses a customized .dbf format with more than 255 columns, Excel won't recognize the extra columns.

    The .dbf file format is binary, you can't treat it as a text file.

    Can you export from Arcgis to a comma-delimited or fixed-width text file?

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='798922' date='19-Oct-2009 22:44']Excel treats .dbf files as DBase files. A DBase file can have a maximum of 255 fields (columns), so it's not surprising that the import stops at column IU (the 255th column).

    If Arcgis uses a customized .dbf format with more than 255 columns, Excel won't recognize the extra columns.

    The .dbf file format is binary, you can't treat it as a text file.

    Can you export from Arcgis to a comma-delimited or fixed-width text file?[/quote]

    another "ah ha!" moment. thanks for the explanation.

    Actually, it's coming from a computer model as a shape file and we're manipulating the data in excel. Someone else is running the model and says it's the only way to get the data out of the model. Googling around, I found a program called dbfviewer which will read it and export it to a tab delimited file, which will then import into excel. Unfortunately, it rounds to 6 decimals, so it's introducing a small round-off error. Will continue to search for an answer.

    Thanks for the help!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •