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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filter transfertext action 2
Error When Using TransferText in a Macro 1
I can't specify the Specification Name when use transfertext 1
transfertext 1
Run time 1004 5
transfertext - select text file? 2
Need to TransferText "LIKE" ... 5
Crosstab query 1

Back
Top