Data is lost when using Transfertext action

[lpdds]

I have a text file that is imported into an access table. As an example, the
file contains the following data:

101,10, 1,04,2South

The space before the "1" is deliberate. The table has all text fields.

The following is imported:

F1 101
F2 10
F3 1
F4 4
F5 2

It does not maintain the space before the "1", deletes the "0" in "04" and
eliminates the word "south" in "2South".

How can I maintain the data in the original format?

Thanks

 

[tina]

in the Import Wizard, you can set the Data Type for each column of data in
the Field Options. set the data type to text. or you can click the Advanced
tab and do it there.

hth