I am currently trying to build a model that will join two excel tables (without xy coordinates) to one shapefile, which will save some time on a very long process that I have to repeatedly do each day at work. I know that there is a way to manually do it if I right-click the shapefile in the table of contents and add a join from that menu; however, there seems to be no way of doing it in the ModelBuilder.
I am guessing it is a similar situation to the two different merge options in the toolbox and in the editor drop down menu, where they share the same name yet function differently. Therefore, I was wondering if there was a way to make a conversion of an excel table to a shapefile in model builder without coordinates? I know that there is a new tool in ArcGIS 10.2 that would probably help me with this, but the updates are not easily accessed at my work (I am currently using 10.0), so are there other ways of doing this?
This may seem like a simple question, but things are a lot more difficult using model builder due to the fact that I need the process to work automatically each time I use the tool and cannot think of a way that would add xy coordinates and delete them each time I use the tool while not messing with the structure of the original input shapefile. What are my options?