Personally, I don't think you want to go down that road since (AFAIK) the issue is not with the data type of the destination field, but is related to the transport. This is a common problem with Excel/Access data transfers, and there is a theory it's affected by the data in the first 8 rows of the spreadsheet. If the first row contains headers, then who knows for sure? One way to ensure the data is transposed as text is to preface the spreadsheet cell data with the apostrophe (') to ensure it is recognized by Access as text. This might be accomplished via a spreadsheet macro. Other than that, the only other viable way I know of would be to use Automation and import the data cell by cell, coercing the problem fields to text during the transfer. I'd favor the apostrophe method, methinks. Perhaps others here will have a better idea.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.