Having trouble using the Excel-to-Table tool in 10.4

AndrewCooksey

I am trying to migrate some data that i have in a Microsoft Access database to a table on my GIS server.  In the past i have used Access to export a table to an Excel spreadsheet and then use the Excel-to-Table tool in ArcGIS to convert the spreadsheet into a table that can then be imported to the server and used in my maps.  for some reason though i keep getting an error (see clip below).  Attached is the spreadsheet i am trying to convert.

TBLOTICProjectInfo.xlsx

VictoriaAnderson

Hi

I've seen another case where this same issue occurred. I took a look at the data and was able to reproduce the issue on my end. I resolved this by opening the document in excel, and modifying the date mode. Can you give this a try and see if this works?

• Open the document in Excel
• Go to "File" then "Options" 
• Under "Advanced" scroll down to "When calculating this workbook: " and check on "Use 1904 date System"
• Save the file as a new name, and try using this in the Excel to Table tool