Importing data question

[tacoboy42]

i have a data file that is formated similar to this

A1111222223333344445555
B2222211115555444433333

i need it to be automatically imorted to a data base in the same order but each row formated the same such as:

A1111222223333344445555
B1111222223333344445555

any idea how i could do this so every time i imort a file like this that it would format automatically?

 

[KeithG]

You would have to write a VBA procedure to reformat each field.