Failed to Load Data in Attribute Table After Join

[McKenzieBredemeyer]

I have a shapefile that I have joined to an Excel spreadsheet and the join was successful, but when I open the attribute table and try to sort a field, an error message pops up the first time saying, "Failed to load data." with "An invalid SQL statement was used." in the More Info section. All the subsequent times I try to sort the table, the main error message changes to "Failed to create the sorted table cursor." but it has the same statement in the More Info section. I am able to sort the attribute table for the shapefile without the join just fine. I am using ArcGIS Pro 3.3, and both my shapefile and Excel sheet is on a SharePoint drive. I have never run into this error before, whether doing joins or not.

[Robert_LeClair · Accepted solution]

So what I'm seeing in the internals is the issue is with the shapefile (for some reason) and is resolved when you export the shapefile to a file geodatabase feature class.  Once this is done, build the join on the fGDB feature class and the Excel file.  Sorting should work as expected.

[McKenzieBredemeyer]

Thank you! Doing the join in the file geodatabase worked.