I'm using Arc Map 10.2.1. I have an Excel spreadsheet with two sheets in it. One sheet I can bring into Arc Map without a problem and the other I cannot. They aren't much different. Here are some screen shots of the Excel sheets and the data in Arc Map. Does anyone know why the second sheet does not come into Arc Map properly? I've read the topics in Formatting a table in Microsoft Excel for use in ArcGIS—Help | ArcGIS for Desktop and can't see what is wrong.
Excel sheet 1
After bringing sheet 1 into Arc Map, here's the attribute table for Sheet1
Excel sheet 2
After bringing sheet 2 into arc map, here's the attribute table for Sheet2. Notice the fields are all null