I'm trying to add an XY table to the map as points. When I do this it turns my date columns into a "Long" data type which results in there just being irrelevant numbers in each row.
What type of table are you using (i.e. CSV)? Can you upload a sample of the table to this thread. You can do this by clicking on the Use advanced editor at the top right of your reply. This will allow you to attach files.
I can't seem to find the Use advanced editor button on the reply screen. The file is an excel file that I've loaded into ArcPro using the XY Table to Point tool. Should I save it as a CSV?
It won't be there if you reply to the question in your Inbox. Click on the question, and then reply. That's when you'll see it:
Here it is, sorry about that.
Try converting the Excel table to a File Geodatabase table first using the Excel to Table tool. Then, convert this table to points using the XY Table to Point.
I'm getting an error message for some reason when I do that:
ExecuteError: ERROR 999999: Something unexpected caused the tool to fail. Please refer to the error help for potential solutions, or contact Esri Technical Support http://esriurl.com/support.The maximum record length has been exceeded.Failed to execute (CreateTable).Failed to execute (ExcelToTable).
I think what's most confusing is that it works fine in ArcMap. I've been able to get around the issue by creating the XY file in ArcMap and then adding the shapefile to ArcPro. Somehow the two programs are loading the information differently. I thought I saw something about ArcPro needing the date column to be in a different format with such as yyyy:mm:dd instead of the dd:mm:yyyy format that I have it in. I just have a ton of different spreadsheets that I would have to change that for and it wouldn't be worth my time right now since I've been able to get around it for the time being. Thanks for all of your help though, I really appreciate you taking the time to look into this.
Retrieving data ...