Exporting joined table fields to new shapefile using ArcMap converts text fields to numbers

Question

I have a problem when exporting to new shapefile by ArcMap 10.5. I use "add join" to join attribute from table (dbf file) to shapefile. Afterword, I need to export it to a new shapefile. It seemed to export successfully except every field contained character (text) in attribute table have been changed to number. However, this problem has not occurred in some computers with same version of ArcMap (10.5). I am not sure that this needs to be technically fixed outside ArcGIS environment or not.

Can anyone help me to solve this problem?

Answer 1

1. Rename normal.mxt

   C:\Users<your user name>\AppData\Roaming\Esri\Desktop10.7\ArcMap\Templates

2. Try making a copy of the shapefile to a file geodatabase feature class, apply the join, and export it as a feature class

3. Also you can try using the Join Field tool to make a join permanent, so try using the tool

4. Check if all the requirements are being followed to perform Join in ArcMap