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!