Data is lost when using Transfertext action

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
What is the field types of this table? It seems that it might be number
fields.Try changing it to Text fields.YOu might also want to make sure the
text delimiter is selected as "comma"
 
Back
Top