Thanks
I'll close this out this way. I work quite often in Excel, but have some Access skills.
What I've been trying to understand are the differences between the two when it comes to number fields.
In Excel, empty cells do not make a field text. In Access it does, even if the tables are all linked Excel files.
The post was to understand what Access was doing in detail.
Sorry if this isn't worth clarifying.