Importing Text file with numbers that need to be text format

[jamphan]

I am trying create a macro that will import a txt file that has just one column of 16 digit numbers. I need to be able to export these numbers and convert them to text format so it will not be an exponent in Access. Also, I need for this macro to replace the existing data in Access table that I am importing to. Is this possible. Right now my macro does import the numbers but the results are exponents and it keeps adding numbers to the existing Access table. Thanks for the continuous help.