Hello,
I'm trying to work with a Excel table containing Lat/Long coordinates for point locations. I formatted the excel table columns and renamed the headers to eliminate spaces, special characters, and numbers. The edited document was saved as a .csv file. ArcMap will allow me to add the .csv using the "Add Data" button, but attempting to open the attribute table crashes the software. Attempting to Display XY Data shows field numbers and no table headers. I tried to export the csv table into a .dbf, but that also crashes the software. I've used portions of this Excel dataset before and did not have similar issues with ArcMap. I thought maybe the file size was an issue, so I deleted all extra columns -- the file is now 189 KB.
Any suggestions with how to move forward?