Database table in SQL Server

1641
6
Jump to solution
08-03-2016 07:15 AM
SarojThapa1
Occasional Contributor III

I have an excel table. I created a database table in SQL Server database platform in ArcMap. I added fields, fields' data type, and domains to some data fields (columns). When I open the table, all I see is just a table with field names only. Can I not view the database table in SQL Server in ArcGIS desktop? Also, how can I populate rest of my records ( rows) in the table?

Thanks 

0 Kudos
1 Solution

Accepted Solutions
BirajaNayak
Esri Contributor

Hi Saroj,

You can check the following steps to append data from Excel sheet to feature class:

1.In ArcMAP, Add data > Browse to the excel sheet > Add the excel in the ArcMap.
2.Right click on the excel from table of content > Display XY data > An "event layer" will be created.
3.Geoprocessing > ArcToolbox > Data Management toolbox > General > Append
4.Input Dataset : Event layer that  created in step 2.
5.Target Dataset : Feature class that you want to append
6.Schema Type : No_Test
7.Field map : Right click on the fields and map it to the excel fields.
8.OK

Here are some links that you can follow-

Append:

http://desktop.arcgis.com/en/desktop/latest/tools/data-management-toolbox/append.htm

Understanding how to use Microsoft Excel files in ArcGIS:

http://desktop.arcgis.com/en/desktop/latest/manage-data/tables/understanding-how-to-use-microsoft-ex...

Thanks,

Biraja

View solution in original post

6 Replies
JoeBorgione
MVP Emeritus

I'm reading several disconnects in your post:

You created a table a table in ArcMap?  Tables are created in ArcCatalog

You open the table and all you see are the fields:  Have you loaded any data into this table?

Where does the Excel spreadsheet fit to this whole equation?

I'm going to go out on a limb here and make a guess or two:  You want your excel data in an Enterprise Geodatabase aka SDE, is that correct?  If so you need to create the table in ArcCatalog and then either use the simple data loader or the append tool to populate your newly created table.  You must also have the correct credentials to create data in that Enterprise Geodatabse.

That should just about do it....
SarojThapa1
Occasional Contributor III

Hey Joe, I created the table in ArcCatalog and I haven't added any data yet. Sorry for the ambiguity. Yes, I want my excel data in an enterprise geodatabase. I have the credentials to create and edit data in the geodatabase. You guessed very right.

Thanks.

0 Kudos
JoeBorgione
MVP Emeritus

Just to further explain the simple data loader and append: these read the data in your excel table, and allow you to map the fields in excel to the fields in your table.

That should just about do it....
0 Kudos
SarojThapa1
Occasional Contributor III

Thanks. You were a huge help.

0 Kudos
BirajaNayak
Esri Contributor

Hi Saroj,

You can check the following steps to append data from Excel sheet to feature class:

1.In ArcMAP, Add data > Browse to the excel sheet > Add the excel in the ArcMap.
2.Right click on the excel from table of content > Display XY data > An "event layer" will be created.
3.Geoprocessing > ArcToolbox > Data Management toolbox > General > Append
4.Input Dataset : Event layer that  created in step 2.
5.Target Dataset : Feature class that you want to append
6.Schema Type : No_Test
7.Field map : Right click on the fields and map it to the excel fields.
8.OK

Here are some links that you can follow-

Append:

http://desktop.arcgis.com/en/desktop/latest/tools/data-management-toolbox/append.htm

Understanding how to use Microsoft Excel files in ArcGIS:

http://desktop.arcgis.com/en/desktop/latest/manage-data/tables/understanding-how-to-use-microsoft-ex...

Thanks,

Biraja

SarojThapa1
Occasional Contributor III

Thanks Biraja.

0 Kudos