I am having a few issues with a join to a File GDB from an Excel .xls file I imported as a table to the FGDB.
The problem being records that are in the original spreadsheet are not appearing in the imported table and when I join and keep all records I am getting null values although I know in the original spreadsheet the values exist. There about 65000 records in the spreadsheet.
I have also tried with a CSV and failed as well as changing integer and double in the field type - can't seem to work out why this is.
The join is one to one, so nothing complex about it at all.
I'm using ArcGIS 10.2.2 for Desktop.