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.
Solved! Go to Solution.
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?
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?
I would have never found that setting if you hadn't pointed it out. It worked out as described.
Thanks!