topic Database table in SQL Server in Geodatabase Questions

Database table in SQL Server

SarojThapa1 — Wed, 03 Aug 2016 14:15:07 GMT

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

Re: Database table in SQL Server

JoeBorgione — Wed, 03 Aug 2016 15:03:49 GMT

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.

Re: Database table in SQL Server

SarojThapa1 — Wed, 03 Aug 2016 15:14:58 GMT

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.

Re: Database table in SQL Server

JoeBorgione — Wed, 03 Aug 2016 15:21:57 GMT

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.

Re: Database table in SQL Server

BirajaNayak — Wed, 03 Aug 2016 15:22:44 GMT

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-excel-files-in-arcgis.htm

Thanks,

Biraja

Re: Database table in SQL Server

SarojThapa1 — Wed, 03 Aug 2016 15:39:43 GMT

Thanks. You were a huge help.

Re: Database table in SQL Server

SarojThapa1 — Wed, 03 Aug 2016 15:40:06 GMT

Thanks Biraja.