Field Type Conversion

[LB79]

Hello,

I'm having a problem importing an Excel sheet to Access.
Attached is a cut down example (returning the same error as my full workbook).

The column in the Excel sheet has a TEXT format.
When I import to Access, most of the data imports (for some reason, even though the Excel column is TEXT it imports as NUMBER) – It creates a table with the correct field name and most of the data is there, but for some reason it omits large chunks of the data (Type Conversion Failure) for no apparent reason.

So my questions are:

• Why would the field import to Access as NUMBER when then entire column in Excel is TEXT?
• Even though Access is changing the field type to number, why is it only importing some of the data (formats in Excel is the same for all entries).
• Is there a way to enforce a particular field type? (the table imports through VBA).

Thanks J

 

[gemma-the-husky]

put the word TEXT in row 2, in the problem column - then delete the row after the import.

OR

save as a csv, and import the csv.

 

[LB79]

Thank you - That seems to have an impact.