Jump to content

 
Photo

Excel files and ArcGIS

- - - - -

  • Please log in to reply
8 replies to this topic

#1
Darren Rattai

Darren Rattai

    Contributor

  • New Member
  • PipPip
  • 26 posts
  • Canada

Hey all,

I am having a problem with a large dataset that I am working with right now. I am attempting to add a field in excel and then bring it back into Arc. I have tried the usual steps i.e. I have simply made a new excel table with the unique ID as one field and my new info as the other field with the intention of doing a simple join to the existing one, but the info that I add to the excel file does not show up when I look at the table in ArcCat?? Can you not have any spaces within a field? This is the only possibility that I can come up with.
The data I am trying to get back onto the shapefile is simply the info that I want to label it with....I am at a loss with this one.

Any help would be greatly appreciated,

Darren Rattai
GIS Tech.
Northridge Energy Development Group

#2
ELeFevre

ELeFevre

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 1,049 posts
  • Gender:Male
  • Location:Louisville, Colorado USA
  • Interests:Cartography, musical instruments, reading, hiking, craft beer
  • United States

Use an underscore instead of space and see if that helps. And make sure the fields are of the same type.



#3
Matthew Hampton

Matthew Hampton

    Hall of Fame

  • Moderator
  • PipPipPipPipPipPipPip
  • 1,310 posts
  • Gender:Male
  • Location:Portland, Oregon
  • Interests:Playing in the mountains and rivers.
  • United States

It could also be related to the file format. Are you saving the table as a dbf?

co-cartographic creator of boringmaps.com


#4
Darren Rattai

Darren Rattai

    Contributor

  • New Member
  • PipPip
  • 26 posts
  • Canada

I made sure that the format is dbf and have taken all spaces out, still not happening...for some reason the OID field shows but has more records than it should...like 100,000 more. It must be saving the file incorrectly. I'll attempt to fiddle with it some more.

Thanks,
Darren

#5
eli

eli

    Key Contributor

  • Validated Member
  • PipPipPip
  • 81 posts
  • Gender:Female
  • Location:Vancouver
  • Canada

What version of ArcMap are you using? With 9.3 (and maybe 9.2, I forget), you can use the Excel file without saving as a dbf. It does help to change the type (category) of field, I've found in the past.

#6
ELeFevre

ELeFevre

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 1,049 posts
  • Gender:Male
  • Location:Louisville, Colorado USA
  • Interests:Cartography, musical instruments, reading, hiking, craft beer
  • United States

It sounds like you need to select the content in the excel sheet that you want to have in your final table and then save the dbf. I believe that's why you're ending up with thousands of unwanted rows. DBFs are finnicky. Or, you can open the excel sheet by double-clicking on it and selecting the appropriate sheet.



#7
Robert2009

Robert2009

    Master Contributor

  • Validated Member
  • PipPipPipPip
  • 122 posts
  • Gender:Male
  • Location:Las Cruces, NM
  • United States

Make sure when you set it up in Excel and save as a dbf file and then close the program and open ArcCatalog and check if the column is there....Also, keep in mind you need to close ArcCatalog or ArcMap before you open MS Excel that way it will work. I have been struggle on that ...but discovered about closed the program first.... I know it is the pain in the butt...

Perhaps, you should run a Search in Google and should be able to find the information about that...I 've found several and it really helps me to troubleshoot the problem. Have you ?

Also, in the MS Excel and in the column, make sure the column is in text if you are going to use text or numbers...

And another important is to select all the columns and set print area that way you won't get unwanted columns....

Good Luck..

Robert
GIS Specialist
USDA-NRCS
Las Cruces, New Mexico

#8
frax

frax

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 2,309 posts
  • Gender:Male
  • Location:Stockholm, Sweden
  • Interests:music, hiking, friends, nature, photography, traveling. and maps!
  • Sweden

I feel that sometimes Arc caches the files, and it may help to save in a new new after a small change.
Hugo Ahlenius
Nordpil - custom maps and GIS
http://nordpil.com/
Twitter

#9
Darren Rattai

Darren Rattai

    Contributor

  • New Member
  • PipPip
  • 26 posts
  • Canada

Hey all,

Thank-you for the help with this topic, I have finally figured this one out and go it to show up...For some reason I could not copy the original data and manipulate it, I had to use the original table. I did save the copy correctly as a dbf...Who knows, I am just happy that I got it to work.

Darren




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->