Importing Data from Excel Spreadsheets Esri（从Excel电子表格Esri导入数据）.pdfVIP

Importing Data from Excel Spreadsheets Dos, don’ts, and updated procedures for ArcGIS 10 By Mike Price, Entrada/San Juan, Inc.  This exercise models data from a well-known gold and base metals mining area in northern Nevada located near the town of Battle Mountain.  Although the sample data is synthetic, it is true to the underlying geology of Battle Mountain, Nevada. Many organizations keep valuable data in Microsoft Excel and comma-separated values (CSV) files. Learn a methodology for importing data kept in Excel and CSV files into ArcGIS that has been updated for ArcGIS 10 and Microsoft Office 2007/2010. Excel spreadsheets have been used since the release of ArcGIS 8 to prepare and import tabular data into a GIS. Previous ArcUser articles described the benefits and limitations of spreadsheets in the version of ArcGIS current at that time. In early 2004, ArcUser editor Monica Pratt wrote “Working with Excel in ArcGIS” (/ news/arcuser/0104/files/excel.pdf). In 2007, the author wrote another article on the same topic, “Mapping and Modeling Groundwater Geochemistry” tool, focusing on ArcGIS 10 and Excel 2007/2010. The tutorial uses (/news/arcuser/0207/files/groundwater.pdf). spreadsheets to create and enhance geologic data. Field samples in- Since these articles were published, Microsoft has released two clude Hydr