I have a huge dataset of housing data which I am trying to upload to ArcPro and then convert to points using XYData.
Every time I convert the data using XYData and the points are created and displayed on the map, there always seems to be points missing, When I cross-reference the dataset and look for the missing points, I always find the data in the table but it hasn't converted.
When I open the uploaded tables to Arc, all points have been uploaded when compared to the initial file. The issue seems to be when I use the 'Display XY Data' function to convert to points.
The dataset being used is very large, each table having 1,000,000+ entries, is there an upper limit on how many rows Arc will convert at any one time? I cannot open in excel and split these files manually as excel also has an upper limit as to how many rows it will allow open in one workbook.
Is there a function other than 'Display XY Data' that I can use to convert the table to points on the map? Any help would be greatly appreciated!