topic Re: Import Excel to Geodatabase in Data Management Questions

Import Excel to Geodatabase

EdwardTanas — Fri, 11 Oct 2013 13:49:57 GMT

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.

Re: Import Excel to Geodatabase

MandarPurohit — Fri, 11 Oct 2013 14:36:37 GMT

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

Re: Import Excel to Geodatabase

EdwardTanas — Fri, 11 Oct 2013 14:42:10 GMT

Thank you ..
as soon as I get the data, I will give it a try

Re: Import Excel to Geodatabase

EdwardTanas — Fri, 11 Oct 2013 15:10:27 GMT

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... 😞

Re: Import Excel to Geodatabase

EdwardTanas — Fri, 11 Oct 2013 15:23:54 GMT

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?

Re: Import Excel to Geodatabase

VinceAngelo — Fri, 11 Oct 2013 18:16:10 GMT

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

Re: Import Excel to Geodatabase

EdwardTanas — Fri, 11 Oct 2013 18:17:33 GMT

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?

Excell field Data dosn't appear in Geodatabase

StephenKent — Wed, 20 Nov 2013 19:28:08 GMT

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?

Re: Import Excel to Geodatabase

WilliamCraft — Sat, 14 Dec 2013 02:52:27 GMT

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.