Work with a .csv file in ArcMap

Discussion created by CJCarsley on Feb 29, 2012
Latest reply on Feb 29, 2012 by CJCarsley
I have two tables with a .csv file extension that I need to merge together and ultimately join to a feature class.
I have encountered a few problems thus far:

1.  Table 1 does not open with any data in ArcMap.  Table 2 opens just fine, and both open correctly with Excel.
     a.  Table 1 has a field name which begins with '_'.  Could this be causing the problem?
2.  I've tried doing a Table to Table conversion, exporting the tables to a file geodatabase, but it still creates an empty output for table 1.
3. I've also tried to simply merge the two files, but that just fails with no output at all.

Any ideas?