xslx to xls table for attribute join, how to keep all reccords?

Discussion created by dmede on Nov 19, 2012
Latest reply on Nov 19, 2012 by JQuinn-esristaff
I have a table of zoning records that I need to join to the geometry for land parcels in ArcGIS 10. But there are too many records, about 430,000 parcels and associated records.

The parcel .shp has been exported to a feature class in a .gdb. The zoning records are an .xlsx file, but Arc only sees that as an empty geometry set. In order to view it as a table I need to convert to.xls but that truncates my records from 430k to 65k. I saved as csv but can't see it as a table or import it into the gdb to use for a table join.

How can I use the xlsx table to join to the zoning feature class so I get all of my records without having to cut the table up into a bunch of smaller tables?