Import failing on decimals

[Mike P]

I am importing a text, tab delimited file into an access table using a File
Specification via the command. I am using Access 2007

DoCmd.TransferText acImportDelim, "myImport_Specification", "tblDates",
gstrImportFile

One of the fields is not importing the data. It is a numeric field that has
decimal numbers without four digits. For example, .0487 and .1932

I have this field set type of the table is set to “number†with the decimal
point set to auto. The numbers are imported with the value of 0. I also
tried to set the field type to “currency†but the data in the able is still 0
after the import.

Any idea of what I am doing wrong. The goal is to have the value of .0487
on the import set to .0487 in the table, not 0.

Thank you in advance for your time!

 

[Klatuu]

Have you tried using either Single or Double data types? Be sure you change
both the field in the destination table and in the import spec.