Transferring dataTransfer data bidirectional between a Feature Class or Table and an Excel table. The settings of the GISconnector for Excel enable a completely variable transfer of data betweeen ArcGIS and Excel. This means that data can be precisely transferred down to a single cell, in accordance with the settings and the data transfer mode (all, selected, or filtered).
RequirementA connection between an ArcGIS Feature Class or Table and an Excel table must be available. If you have not yet created a connection click on the button
![]() ![]() In order to transfer data it is not necessary to start an edit session in ArcGIS.
You have three different options for transferring data:
![]() ![]() ![]() ![]() ![]() Before you start the data transfer you should briefly click
![]() When you have selected your settings click the button
![]() If you transferred data from Excel to ArcGIS and have an open edit session at the same time, you can undo the changes made through the data transfer by pressing the "Undo" Button
![]() ![]() In some cases an open attribute table window in ArcMap will not be refreshed after transferring data from Excel to ArcGIS. This applies to Feature Classes opened in different ArcMap documents at the same time and Standalone Tables that are not joined to Feature Classes. You can do a manual refresh by using the “Reload cache” option in the “Table Options” menu of the table window or by closing and reopening the whole attribute table window.
![]() The speed of the transfer can be strongly improved. Read more about this in the chapter "Performance optimization".
![]() The data transfer did not work? Look here for trouble shooting.
|