ArcGIS, Access, and Sharepoint [on hold]

[المشرف العام]

I have designed and implemented an InfoPath form that users fill out off-net to retrieve and select data from a back end access db. I receive the submitted form through email and then process them up to a SharePoint library. Now I need to take those forms, dump to a db, and create a db that is easily joined to ArcGIS 10.0 geodatabase feature class(es). My dilemma is finding the right solution:

• an export of SP library columns to Access (synced to SP)
• export to standalone gdb table
• Query layers?

I should note that the join/relate will need to be a one (feature class) to many (table) relationship

I have a variety of users/clients that use only excel, access, ArcGIS, or combinations of all.

Trying to find a fairly automated solution for continual updates. Will need to perform spatial queries and analysis to table data.



أكثر...