Skip to main content
deleted 447 characters in body
Source Link

ArcGIS does not have full functionality for csv or Excel files. They are essentially for import and other input tasks. It is like asking why Excel cannot add rows or columns to my file geodatabase.

It is likely nothing to do with permissions. You are trying to use a wrench to turn in a screw. Use a screwdriver (geodatabase table in this terrible analogy).

This link will help you understand. Here are some key points to consider from the ESRI help site.

  • ArcGIS supports both Excel 2003 and earlier .xls files and Excel 2007 .xlsx files. One advantage of Excel 2007 is that it allows much larger worksheets (1,048,576 rows by 16,384 columns) than you can have in Excel 2003 (65,536 rows by 256 columns).
  • If you have an .xlsx file you want to use in ArcGIS but do not have Excel 2007 installed, you will need to install the 2007 Office System Driver. It can be downloaded from the Microsoft Download Center. If you have Microsoft Excel 2010 or no version of Microsoft Excel installed, you must install the 2007 driver before you can use either .xls or .xlsx files.
  • Excel tables are read-only in ArcGISExcel tables are read-only in ArcGIS as well as in Excel when you have a workbook open in ArcGIS.
  • Field names are derived from the first row in each column of the worksheet. You can view the properties, set aliases for the field names, and set field visibility on the Fields tab of the table's Properties dialog box.
  • Excel does not enforce field types for values during data entry like standard databases do. Therefore, the field type specified in Excel is not used in determining the field type exposed in ArcGIS. Instead, field type in ArcGIS is determined by a scan of the values in the first eight rows for that field. If the scan finds mixed data types in a single field, that field will be returned as a string field, and the values will be converted to strings.
  • Numeric fields are converted to the double data type in ArcGIS. Excel tables behave like other tables that don't have an ObjectID field. This means you will be unable to edit, perform relates, or make selections on the map.
  • Excel file support in ArcGIS uses Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel Indexed Sequential Access Method (ISAM) driver. For more information on the Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel ISAM, see Microsoft KB article 326548.Excel file support in ArcGIS uses Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel Indexed Sequential Access Method (ISAM) driver.
  • You can directly export to Excel by using the Export To Excel tool from the Geoprocessing Model & Script Tool Gallery. You can also export tabular data to dBASE format, which can be opened in Excel 97/2003 and saved as an .xls file. Microsoft discontinued support for .dbf files in Office 2007.
  • You can still open an Excel file through an OLE DB database connection.You can still open an Excel file through an OLE DB database connection.

ArcGIS does not have full functionality for csv or Excel files. They are essentially for import and other input tasks. It is like asking why Excel cannot add rows or columns to my file geodatabase.

It is likely nothing to do with permissions. You are trying to use a wrench to turn in a screw. Use a screwdriver (geodatabase table in this terrible analogy).

This link will help you understand.

  • ArcGIS supports both Excel 2003 and earlier .xls files and Excel 2007 .xlsx files. One advantage of Excel 2007 is that it allows much larger worksheets (1,048,576 rows by 16,384 columns) than you can have in Excel 2003 (65,536 rows by 256 columns).
  • If you have an .xlsx file you want to use in ArcGIS but do not have Excel 2007 installed, you will need to install the 2007 Office System Driver. It can be downloaded from the Microsoft Download Center. If you have Microsoft Excel 2010 or no version of Microsoft Excel installed, you must install the 2007 driver before you can use either .xls or .xlsx files.
  • Excel tables are read-only in ArcGIS as well as in Excel when you have a workbook open in ArcGIS.
  • Field names are derived from the first row in each column of the worksheet. You can view the properties, set aliases for the field names, and set field visibility on the Fields tab of the table's Properties dialog box.
  • Excel does not enforce field types for values during data entry like standard databases do. Therefore, the field type specified in Excel is not used in determining the field type exposed in ArcGIS. Instead, field type in ArcGIS is determined by a scan of the values in the first eight rows for that field. If the scan finds mixed data types in a single field, that field will be returned as a string field, and the values will be converted to strings.
  • Numeric fields are converted to the double data type in ArcGIS. Excel tables behave like other tables that don't have an ObjectID field. This means you will be unable to edit, perform relates, or make selections on the map.
  • Excel file support in ArcGIS uses Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel Indexed Sequential Access Method (ISAM) driver. For more information on the Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel ISAM, see Microsoft KB article 326548.
  • You can directly export to Excel by using the Export To Excel tool from the Geoprocessing Model & Script Tool Gallery. You can also export tabular data to dBASE format, which can be opened in Excel 97/2003 and saved as an .xls file. Microsoft discontinued support for .dbf files in Office 2007.
  • You can still open an Excel file through an OLE DB database connection.

ArcGIS does not have full functionality for csv or Excel files. They are essentially for import and other input tasks. It is like asking why Excel cannot add rows or columns to my file geodatabase.

It is likely nothing to do with permissions. You are trying to use a wrench to turn in a screw. Use a screwdriver (geodatabase table in this terrible analogy).

This link will help you understand. Here are some key points to consider from the ESRI help site.

  • ArcGIS supports both Excel 2003 and earlier .xls files and Excel 2007 .xlsx files.
  • If you have an .xlsx file you want to use in ArcGIS but do not have Excel 2007 installed, you will need to install the 2007 Office System Driver.
  • Excel tables are read-only in ArcGIS as well as in Excel when you have a workbook open in ArcGIS.
  • Field names are derived from the first row in each column of the worksheet. You can view the properties, set aliases for the field names, and set field visibility on the Fields tab of the table's Properties dialog box.
  • Excel does not enforce field types for values during data entry like standard databases do. Therefore, the field type specified in Excel is not used in determining the field type exposed in ArcGIS. Instead, field type in ArcGIS is determined by a scan of the values in the first eight rows for that field. If the scan finds mixed data types in a single field, that field will be returned as a string field, and the values will be converted to strings.
  • Numeric fields are converted to the double data type in ArcGIS. Excel tables behave like other tables that don't have an ObjectID field. This means you will be unable to edit, perform relates, or make selections on the map.
  • Excel file support in ArcGIS uses Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel Indexed Sequential Access Method (ISAM) driver.
  • You can directly export to Excel by using the Export To Excel tool from the Geoprocessing Model & Script Tool Gallery. You can also export tabular data to dBASE format, which can be opened in Excel 97/2003 and saved as an .xls file. Microsoft discontinued support for .dbf files in Office 2007.
  • You can still open an Excel file through an OLE DB database connection.
Spelling error
Source Link
Fezter
  • 22k
  • 11
  • 71
  • 126

ArcGIS does not have full functionality for csv or Excel files. They are essentially for import and other input tasks. It is like asking why Excel cannot add rows or columns to my file geodatabase.

It is likely notingnothing to do with permissions. You are trying to use a wrench to turn in a screw. Use a screwdriver (geodatabase table in this terrible analogy).

This link will help you understand.

  • ArcGIS supports both Excel 2003 and earlier .xls files and Excel 2007 .xlsx files. One advantage of Excel 2007 is that it allows much larger worksheets (1,048,576 rows by 16,384 columns) than you can have in Excel 2003 (65,536 rows by 256 columns).
  • If you have an .xlsx file you want to use in ArcGIS but do not have Excel 2007 installed, you will need to install the 2007 Office System Driver. It can be downloaded from the Microsoft Download Center. If you have Microsoft Excel 2010 or no version of Microsoft Excel installed, you must install the 2007 driver before you can use either .xls or .xlsx files.
  • Excel tables are read-only in ArcGIS as well as in Excel when you have a workbook open in ArcGIS.
  • Field names are derived from the first row in each column of the worksheet. You can view the properties, set aliases for the field names, and set field visibility on the Fields tab of the table's Properties dialog box.
  • Excel does not enforce field types for values during data entry like standard databases do. Therefore, the field type specified in Excel is not used in determining the field type exposed in ArcGIS. Instead, field type in ArcGIS is determined by a scan of the values in the first eight rows for that field. If the scan finds mixed data types in a single field, that field will be returned as a string field, and the values will be converted to strings.
  • Numeric fields are converted to the double data type in ArcGIS. Excel tables behave like other tables that don't have an ObjectID field. This means you will be unable to edit, perform relates, or make selections on the map.
  • Excel file support in ArcGIS uses Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel Indexed Sequential Access Method (ISAM) driver. For more information on the Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel ISAM, see Microsoft KB article 326548.
  • You can directly export to Excel by using the Export To Excel tool from the Geoprocessing Model & Script Tool Gallery. You can also export tabular data to dBASE format, which can be opened in Excel 97/2003 and saved as an .xls file. Microsoft discontinued support for .dbf files in Office 2007.
  • You can still open an Excel file through an OLE DB database connection.

ArcGIS does not have full functionality for csv or Excel files. They are essentially for import and other input tasks. It is like asking why Excel cannot add rows or columns to my file geodatabase.

It is likely noting to do with permissions. You are trying to use a wrench to turn in a screw. Use a screwdriver (geodatabase table in this terrible analogy).

This link will help you understand.

  • ArcGIS supports both Excel 2003 and earlier .xls files and Excel 2007 .xlsx files. One advantage of Excel 2007 is that it allows much larger worksheets (1,048,576 rows by 16,384 columns) than you can have in Excel 2003 (65,536 rows by 256 columns).
  • If you have an .xlsx file you want to use in ArcGIS but do not have Excel 2007 installed, you will need to install the 2007 Office System Driver. It can be downloaded from the Microsoft Download Center. If you have Microsoft Excel 2010 or no version of Microsoft Excel installed, you must install the 2007 driver before you can use either .xls or .xlsx files.
  • Excel tables are read-only in ArcGIS as well as in Excel when you have a workbook open in ArcGIS.
  • Field names are derived from the first row in each column of the worksheet. You can view the properties, set aliases for the field names, and set field visibility on the Fields tab of the table's Properties dialog box.
  • Excel does not enforce field types for values during data entry like standard databases do. Therefore, the field type specified in Excel is not used in determining the field type exposed in ArcGIS. Instead, field type in ArcGIS is determined by a scan of the values in the first eight rows for that field. If the scan finds mixed data types in a single field, that field will be returned as a string field, and the values will be converted to strings.
  • Numeric fields are converted to the double data type in ArcGIS. Excel tables behave like other tables that don't have an ObjectID field. This means you will be unable to edit, perform relates, or make selections on the map.
  • Excel file support in ArcGIS uses Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel Indexed Sequential Access Method (ISAM) driver. For more information on the Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel ISAM, see Microsoft KB article 326548.
  • You can directly export to Excel by using the Export To Excel tool from the Geoprocessing Model & Script Tool Gallery. You can also export tabular data to dBASE format, which can be opened in Excel 97/2003 and saved as an .xls file. Microsoft discontinued support for .dbf files in Office 2007.
  • You can still open an Excel file through an OLE DB database connection.

ArcGIS does not have full functionality for csv or Excel files. They are essentially for import and other input tasks. It is like asking why Excel cannot add rows or columns to my file geodatabase.

It is likely nothing to do with permissions. You are trying to use a wrench to turn in a screw. Use a screwdriver (geodatabase table in this terrible analogy).

This link will help you understand.

  • ArcGIS supports both Excel 2003 and earlier .xls files and Excel 2007 .xlsx files. One advantage of Excel 2007 is that it allows much larger worksheets (1,048,576 rows by 16,384 columns) than you can have in Excel 2003 (65,536 rows by 256 columns).
  • If you have an .xlsx file you want to use in ArcGIS but do not have Excel 2007 installed, you will need to install the 2007 Office System Driver. It can be downloaded from the Microsoft Download Center. If you have Microsoft Excel 2010 or no version of Microsoft Excel installed, you must install the 2007 driver before you can use either .xls or .xlsx files.
  • Excel tables are read-only in ArcGIS as well as in Excel when you have a workbook open in ArcGIS.
  • Field names are derived from the first row in each column of the worksheet. You can view the properties, set aliases for the field names, and set field visibility on the Fields tab of the table's Properties dialog box.
  • Excel does not enforce field types for values during data entry like standard databases do. Therefore, the field type specified in Excel is not used in determining the field type exposed in ArcGIS. Instead, field type in ArcGIS is determined by a scan of the values in the first eight rows for that field. If the scan finds mixed data types in a single field, that field will be returned as a string field, and the values will be converted to strings.
  • Numeric fields are converted to the double data type in ArcGIS. Excel tables behave like other tables that don't have an ObjectID field. This means you will be unable to edit, perform relates, or make selections on the map.
  • Excel file support in ArcGIS uses Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel Indexed Sequential Access Method (ISAM) driver. For more information on the Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel ISAM, see Microsoft KB article 326548.
  • You can directly export to Excel by using the Export To Excel tool from the Geoprocessing Model & Script Tool Gallery. You can also export tabular data to dBASE format, which can be opened in Excel 97/2003 and saved as an .xls file. Microsoft discontinued support for .dbf files in Office 2007.
  • You can still open an Excel file through an OLE DB database connection.
Source Link

ArcGIS does not have full functionality for csv or Excel files. They are essentially for import and other input tasks. It is like asking why Excel cannot add rows or columns to my file geodatabase.

It is likely noting to do with permissions. You are trying to use a wrench to turn in a screw. Use a screwdriver (geodatabase table in this terrible analogy).

This link will help you understand.

  • ArcGIS supports both Excel 2003 and earlier .xls files and Excel 2007 .xlsx files. One advantage of Excel 2007 is that it allows much larger worksheets (1,048,576 rows by 16,384 columns) than you can have in Excel 2003 (65,536 rows by 256 columns).
  • If you have an .xlsx file you want to use in ArcGIS but do not have Excel 2007 installed, you will need to install the 2007 Office System Driver. It can be downloaded from the Microsoft Download Center. If you have Microsoft Excel 2010 or no version of Microsoft Excel installed, you must install the 2007 driver before you can use either .xls or .xlsx files.
  • Excel tables are read-only in ArcGIS as well as in Excel when you have a workbook open in ArcGIS.
  • Field names are derived from the first row in each column of the worksheet. You can view the properties, set aliases for the field names, and set field visibility on the Fields tab of the table's Properties dialog box.
  • Excel does not enforce field types for values during data entry like standard databases do. Therefore, the field type specified in Excel is not used in determining the field type exposed in ArcGIS. Instead, field type in ArcGIS is determined by a scan of the values in the first eight rows for that field. If the scan finds mixed data types in a single field, that field will be returned as a string field, and the values will be converted to strings.
  • Numeric fields are converted to the double data type in ArcGIS. Excel tables behave like other tables that don't have an ObjectID field. This means you will be unable to edit, perform relates, or make selections on the map.
  • Excel file support in ArcGIS uses Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel Indexed Sequential Access Method (ISAM) driver. For more information on the Microsoft OLE DB Provider for Jet 4.0 and its supporting Excel ISAM, see Microsoft KB article 326548.
  • You can directly export to Excel by using the Export To Excel tool from the Geoprocessing Model & Script Tool Gallery. You can also export tabular data to dBASE format, which can be opened in Excel 97/2003 and saved as an .xls file. Microsoft discontinued support for .dbf files in Office 2007.
  • You can still open an Excel file through an OLE DB database connection.