nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Import Excel to Geodatabase

EdwardTanas

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.

Trouver plus de publications taguées avec

Accepted answers

All comments

MandarPurohit

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

EdwardTanas

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

EdwardTanas

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

EdwardTanas

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?

VinceAngelo

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

EdwardTanas

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?

StephenKent

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?

WilliamCraft

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.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.