SDSFIE Geodatabase & Excel .xlsx file Input: How to upload the data?

Question

Hi all,
I have a new empty geodatabase and an Excel .xlsx.file input file for upload it into the empty geodatabase-see the attached 2 files for details. This empty geodatabase is from USACE SDSFIE 3.1 Gold that is for the "EnvironmentalSampleLocation" Point format.  Please kindly help and tell me how I can upload the Excel .xlsx file into the empty geodatabase file>
Thanks in advance,
Scott Chang

Lisa-shcPersonalGDB_Pts_in_SDSFIE-3.1-Gold.docx

FtMcNair8Pts.xlsx

JeffreyThompson2_0-1775053531781.png

VHolubec_0-1775052476588.png

JoeBorgione · Answer

Hi Joe, Thanks for your nice response.

I am new in doing this kind of things and I need your detailed instructions to do the 2 ways of uploading the Excel .xlsx data into the empty SDSFIE geodatabase: (i) Where (in ArcMap or ArcCatalog) should I start doing "import it with the import table command? (ii) If I do the "Display XY data" in ArcMap, how can I be sure it is associted with the SDSFIE geodatabase I had?  Frankly speaking, I don't know what the fields of "EnvironmentalSampleLocation" are for!!??  I am confused now.  Please kindly help and give me more detailed instructions for (i) and (ii).

Many Thanks again,
Scott Chang

You probably ought to get a little more familiar with what ArcGIS does, some basic nomenclature etc.  Here is the link to the version 10 online help; http://help.arcgis.com/en/arcgisdesktop/10.0/help/  Start with the essentials library.

Back to your questions:
i) In ArcCatalog, right click on your database and select Import.  Then select Table(single) and follow the dialog windows to navigate to your xlsx file.
ii) When you Display XY data, that's all you are doing; displaying it on your map.  You can create an actual feature class by right clicking on the 'XY Events' layer in the table of contents and selecting Data and then Export Data.  The dialog window allows you to navigate to a geodatabase of your choosing, and allows you to give the feature class a name.  The geodatabase should be created already; if not there is a little database icon with an asterisk on it that allows you to create a new filegeodatabase.

Finally-  I can't help you with what fields are are in the xlxs table, nor can I help you with what fields you need for your database. Those issues are up to you to resolve.

Anonymous User · Answer

Original User: ScottChang25

Hi Joe, Thanks for your nice response.

I am new in doing this kind of things and I need your detailed instructions to do the 2 ways of uploading the Excel .xlsx data into the empty SDSFIE geodatabase: (i) Where (in ArcMap or ArcCatalog) should I start doing "import it with the import table command? (ii) If I do the "Display XY data" in ArcMap, how can I be sure it is associted with the SDSFIE geodatabase I had?  Frankly speaking, I don't know what the fields of "EnvironmentalSampleLocation" are for!!??  I am confused now.  Please kindly help and give me more detailed instructions for (i) and (ii).

Many Thanks again,
Scott Chang

MatthiasAbele1 · Answer

Hi all,
I have a new empty geodatabase and an Excel .xlsx.file input file for upload it into the empty geodatabase-see the attached 2 files for details. This empty geodatabase is from USACE SDSFIE 3.1 Gold that is for the "EnvironmentalSampleLocation" Point format.  Please kindly help and tell me how I can upload the Excel .xlsx file into the empty geodatabase file>
Thanks in advance,
Scott Chang

Hallo,

I also have to load tables into Geodatabases quite often; I use the GISconnector for Excel to do it.

It is easy and fast and afterwards you can still edit your data from Excel.

Good luck!

M