I have joined two tables (excel 10 but saved as 03 to import it into ArcGIS) in ArcGIS 10 based on a column. This column has some empty records in both tables. I need the agreeing records to be added to the right and the others to be on the bottom of the table. After fiddling with it I got it to work; we filled in the empty cells of that column with dummy numbers. Anyway, the problem now is that when I export the joined table, the second (right) half of it is empty (all zeroes) even though the joined table was just fine. I tried exporting it as dbf and txt and neither worked.
Does anybody have an idea how to fix this? Thanks a bunch!