How can i join multiple excel data for every single Polygon?

Question

Hello. The problem is; there is too much data for a single polygon. I have 55 polygon and nearly 950 Excel data. I cant directly join Excel. Because, Polygon's Attribute Table just showing one data for every single polygon. I tried that; "Make Query Table" tool. Thanks to it, I can combine excel data and polygon data as a table. But i cant join it. I want analyst this excel data. I tryed edit .dbf file, but Arcgis has an error and not opened it. How can i join it to shpfile?

JoeBorgione · Answer

Check your field names; be sure they don't start with a number and/or have special characters in them.

Well.... I've been using ESRI products since 1990 and have always been able to perform spatial analyses with all of them.

FurkanGenişyürek · Answer

This gave an Error. I wanna just spatial analyst with data.. Apparently there is no such thing in ArcGIS. Thank you..

JoeBorgione · Answer

That is not the tool to use: see the online help linked in my post above.  All that step does is take the excel spread sheet and convert it into an ArcGIS data table.  You will be limited in your analytical approaches if you are using shapefles and converting the excel spreadsheet into a .dbf table.  I strongly urge you to use a File Geodatabse in which to store your data, both spatial and tablular.