Bug
Exporting a layer that has a join to an Excel file with field names that contain a comma cause ArcMap to crash.
| Bug ID Number | NIM039649 |
|---|---|
| Submitted | October 24, 2008 |
| Last Modified | April 2, 2025 |
| Applies to | No Product Found |
| Version found | 9.3 |
| Status | Duplicate |
Description
Exporting a layer with a comma in a field name causes ArcMap to crash.Cause
This can commonly occur when using Microsoft Excel worksheets within ArcMap. ArcMap allows worksheets with a field name that contains a comma to be added as data to the map; however, performing an operation like 'exporting the table or layer' requires that ArcMap use the true schema of the data.In the export process, ArcMap reads through all the field names of the dataset and separates them with a comma. As a result, any field that contains a comma inadvertently causes ArcMap to fail, because the export functionality tries to interpret a field that does not exist.
Common workflows that could encounter this problem:
▪ Exporting an X,Y event layer
▪ Exporting a layer with a join to an Excel worksheet
Workaround
Remove the comma in the field name using Microsoft Excel.Steps to Reproduce
Bug ID: NIM039649
Software:
- No Product Found
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App