Error when opening an Excel table in ArcMap 9.3

Discussion created by janicooper on Apr 4, 2014
Latest reply on Apr 7, 2014 by janicooper
Hey guys,

I've added an excel worksheet to my workspace but when I try to open the attribute table I get an error message about loading the records(Please see attached image).  It obviously has something to do with the formatting of the rows and I read that Arc decides the field type for each field based on the first 8 rows of data.  So it's telling me that with the fields "OIDTable4" and "Comments_Special_Notes" there's an issue with a value in one of the rows.  I don't know what the OIDTable4 is, it's no where in my table.  And there is a "Comments_Special_Notes" field but I can't find the issue with any values. I've read through the ArcHelp section about specific formatting of Excel files before adding them to ArcMap.  If anyone has any suggestions or advice, please let me know.