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.
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!
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
