Hi fellas

Ive managed to successfully use the TransferText function to port a csv file to an access database. But of course there is one last nagging problem.

For a certian field, the data that i get can sometimes contain just integers or it can contain char's and integers.

This is where the probem arises....
TransferText seems to automate some sort of recognition that automatically does a determination on the type that is being read... after filling the access DB using TransferText i get an error 'Type Conversion Failure'. The error concerns the data that is a combination of chars and integers (it doesnt like it!) and looking at the other data in the same field it seems that the data has been converted to integer? as I have the following:

C00000000012 <=== data giving error and hence not being
populated
678 <=== data is populated into DB like this but it was
originally 000000000678

How can I fix this or specify (using VB Code) the type that TransferText should be converting too? (I want text type only!)

Thanks for ANY Help!