Hello all!!!
I have a form in Access which imports a CSV file into a table as follows:

DoCmd.TransferText acImportDelim, , tblName, InputDir & ImportFile, True

I am having a very strange problem though. There are certain fields in the table of type text but when the imported data appears to be numeric (the first line has data like '34' but subsequent are like '34b') the textual data is not imported. A "TYPE CONVERSION FAILURE" occurs.

Does anyone have any ideas how to overcome this. The data is from large extracts so resorting to begin with text records manually is not really an option!!

Any help is appreciated.

Cheers