convert txt file

[anu]

hi, is anyone can help me to write a program in Microsoft Access to convert "test.txt" to a tab delimited file.
All fields must be trimmed of extra spaces.



file is attached below.

and then include a form to specify the input and output and a button to run the conversion.
Do not use Macros to perform the conversion (i.e. TransferText)

Info:
"test.txt" is a fixed width (811 byte) vertical bar delimited file.

[RuralGuy]

I would look up Open(n), Read(n), Write(n) and Replace() in help and then give it a shot.