Connect Excel data to ArcGIS data
Objective: Create a data connection between your Excel and ArcGIS data.
Choose the upper left column heading of your data table in your spreadsheet. In this example, the table origin resp. the column headings start at A1.
Important advice:
The GISconnector assumes that all columns and rows adjacent to the table origin belong to this table. The recognition of further columns can be prevented by an empty column or a column without heading. Respectively, the recognition of further rows can be avoided by an empty row.
1. In the first step, you see a summary of you Excel data source.
Press "Next >".
2. At the second step, choose "Connect Excel data with existing ArcGIS data"
Press "Next >".
3. In the third step, select the ArcGIS data source which should be connected to your Excel data.
Press "Next >".
4. Choose the key columns which should be used to match your ArcGIS and Excel data. After connecting your data based on the given columns,
the GISconnector creates own GCEX_ID columns on the ArcGIS- and Excel-side to manage the connection henceforth.
Press "Next >".
Important notice:
If you have activated the expert mode you can additionally define which columns should be managed by the GISconnector. Futhermore, you can set the transfer options regarding columns and rows for the connection you are about to create. If you do not use the expert mode, the GISconnector will keep the standard options defined in the basic settings.
4. Enter a name for your connection or keep the default name.
Press "Finish >".
Hint: Generally we recommend to activate respectively let the GISconnector for Excel manage only those columns you intend to transfer in order to maximize speed. (see also performance optimization).
|