text transfer

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

JIM.H.

Hello,
I am using the following format to import data from a
comma delimited file.

DoCmd.TransferText acImportDelim, ,MyTable, fileNamePath,
False

My first column is actually a text type in MyTable and in
the file it is a number which has some zeros on the left
side. The problem is when the text file is transferred to
the table, first column looses zeros at the left side of
the number. How can I keep zeros in there?
Thanks,
Jim.
 
Jim,
Access is assuming that the data in that column is
numeric, therefore it is importing as a numeric type and
dropping the preceding zeros.

You need to create an import specification. In the
specification declare that column as text, that will
retain the preceding zeros.
Hope this helps
Rosco
 
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

Export of text field trims leading zeros 1
custom warning message for data import 1
TransferText using wrong format 0
cannot follow file path? 7
Why does TransferText trim when importing string 7
Problem with access acImportDelim importing csv with headers 1
Transfer Text Export 5
Importing text file with append 1

Back
Top