Cleaning up ACT! field problems

I've had problems in the past with displayed fields not connected properly to the data, but I haven't got very far in trying to fix the issues. I just installed ACT on a new computer and restored the database. After syncing with some new contacts from Cardscan (following the problems with direct Outlook sync I'm back with Cardscan), I noticed that the previous field issue is still there, so decided to investigate by creating a test contact in Cardscan.

The fields that I noticed are messed up (there may be more) are the address and assistant fields.The assistant field isn't present in the Cardscan map, but after syncing the ACT contact contains the address information in the assistant field. I synced from Cardscan to Outlook and didn't have the problem.

So now I think that the ACT database is messed up and I've been carrying this problem along for a while. I've done check/repair but that hasn't had any effect.

I'd like to ask the group the best approach to fixing it. It seems that I can import from a different database, so if I can get one version of the database with the correct data I should be OK importing to a new one. I'll export from the problem database first to a spreadsheet to check which fields are messed up and then make corrections. Is that the best way to clear it up?

Mike,
I've been looking at the field problem in more detail. I think it was caused by me a couple of years ago. I created a new database and then synced from CardScan, then exported from ACT to look in Excel. All the fields are connected correctly, although there are some additional fields compared to my previous database - some appear to be created by ACT, so I wonder if the database update was somehow messed up. A couple of oddities -
The CardScanID didn't appear in ACT, but it was in the old database
The old database has fields like Snapshot Contact Grade, 2nd Last reach, and more that don't appear in the new database. I don't know if that's because the new one hasn't been used.

Some of the fields I created are fine, but the Assistant field is not correctly mapped, and neither is Zip code.

So, my question is, will it work for cleaning up the fields to transfer data from the old database? I'm looking at the import, and can see that Assistant and a couple of others are incorrectly suggested in the mapping. So it looks like I'll have to create some new fields to allow me to set up the map. But will I get the history? No harm in trying I guess.

And how do I get the layout that I created from the old database? Maybe it is just safer to create a new one.