Import failing on decimals

  • Thread starter Thread starter Mike P
  • Start date Start date
M

Mike P

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

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, between 0 and 1, with four digits to the right of the
decimal. For example, .0487 and .1932

I have this field type of the table is set to “number†with the decimal
point set to auto. All numbers are imported with the value of 0. I also
tried to set the field type to “currency†but the data in this one column of
the table is still 0 after the import. All the other fields are working
fine, they are text, number (without decimals), and date.

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.

Thanks,
Mike P.
 
Ensure the number type is set to Double.
It sounds like you have it set to Long or Short Integer. Integers are whole
numbers (no decimals).
 
Back
Top