You may need to document a cross-reference of the internal and
external names of the fields in your tables. As I remember it,
internal names are 8 characters and external names are 10 characters.
DataTypes may be a problem, but it has been so long, I don't remember.
I also had problems with linking DBF database tables in Access, so I
created temp tables as free tables then exported then to CVS or TXT.
I used Excel to clean up data problems, then imported the Excel files
into Access.
Ron