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. 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!
 
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.
 
Back
Top