Import Excel to Geodatabase

14066
8
10-11-2013 06:49 AM
EdwardTanas
New Contributor
Need a refresher..

I have a task that consists of importing an excel spreadsheet into a new Geodatabase that I have to create...
best workflow to import Excel into the Geodatabase is??

Our Field Inspector software is designed to be connected to a geo-database to store all collected data and defines of the specific
fields shown on the field inspector unit (data collector). I have  a sample of the pipe data we collect in the field and the pipe tallies
that are used for QC in that process.  Field Inspectors needs a geo-database that can be created in ArCatalog and then transferred
to the unit that is used in the field..

Suggestions??

Thank you for all your help.
0 Kudos
8 Replies
MandarPurohit
New Contributor III
The 'Excel to Table' geoprocessing tool could be an option for you.

http://resources.arcgis.com/en/help/main/10.2/index.html#/Excel_To_Table/001200000055000000/

Mandar
0 Kudos
EdwardTanas
New Contributor
Thank you ..
as soon as I get the data, I will give it a try
0 Kudos
EdwardTanas
New Contributor
The 'Excel to Table' geoprocessing tool could be an option for you.

http://resources.arcgis.com/en/help/main/10.2/index.html#/Excel_To_Table/001200000055000000/

Mandar


Oh darn I am using Arc 10.1..that tool is not available...in 10.1... :(
0 Kudos
EdwardTanas
New Contributor
The 'Excel to Table' geoprocessing tool could be an option for you.

http://resources.arcgis.com/en/help/main/10.2/index.html#/Excel_To_Table/001200000055000000/

Mandar



and then from there importing the table into the Geodatabase is fairly straight forward, eh?
0 Kudos
VinceAngelo
Esri Esteemed Contributor
and then from there importing the table into the Geodatabase is fairly straight forward, eh?


After running that tool, the table is already in a geodatabase.

- V
0 Kudos
EdwardTanas
New Contributor
After running that tool, the table is already in a geodatabase.

- V


I do not have 10.2,  I only have 10.1... can you guide where to get that toolbox or attach it to here?
0 Kudos
StephenKent
New Contributor
I have an excel spreadsheet that has the following values, 0_10,10_20,20_plus. This is the only column that isn't populated when I create my geodatabase. Any suggestions on how to fix the data so it does appear?
0 Kudos
WilliamCraft
MVP Regular Contributor
For 10.1, check out the help file here: http://resources.arcgis.com/en/help/main/10.1/index.html#//005s0000001w000000

"You can open Microsoft Office Excel tables directly in ArcGIS and work with them like other tabular data sources. For example, you can add them to ArcMap, preview them in ArcCatalog, and use them as inputs to geoprocessing tools."

From there, you can create a file geodatabase and then export your Excel table from the ArcMap table of contents to a table within your new file geodatabase by right clicking it and choosing Export Data.
0 Kudos