Hi , I'm trying to export 1.4m rows of an attribute table created from some spacial analysis out of ARC GIS 10.2 and into a text file for further work in R . I've used the export function on the table view and in the dialog box , chosen to select all records and export to an output table as a text file. When I look at the text file however , only 149,505 rows have been exported from the original 1.4m?
Anyone got an idea of where I'm going wrong here?
Thank you .
Solved! Go to Solution.
If your file is a shapefile, you can browse to it in windows explorer and open the .dbf file. This will open it in excel.
You can then save the file as a text file from excel. Make sure you don't change anything when you open the .dbf file because it could corrupt your shapefile.
Steven
Hi Andrew,
Does the same issue occur if you export to a DBF, or to a File Geodatabase table?
If your file is a shapefile, you can browse to it in windows explorer and open the .dbf file. This will open it in excel.
You can then save the file as a text file from excel. Make sure you don't change anything when you open the .dbf file because it could corrupt your shapefile.
Steven
Thanks to both you Steven and Jake,
I think that help has done enough to move me on . Every time I tried to export the full dataset as a dbf ARC GIS crashed and shutdown however I can break the data into two smaller exports as dbf files and that works OK . I can then open each in Excel 2015 and save as txt or csv files . The recombination to a full dataset can then be done in R .
Best Regards
Andrew