Import failing on decimals

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.
 
O

Olduke

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).
 

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

Import failing on decimals 1
CSV import error only with code 1
Import Trailing Spaces 8
Decimal Truncation Issue upon Import - Access 2007 1
Import CSV Type Conversion Failure 3
Import & export tables based on table data and docmd 14
Importing a text file without decimals 1
import csv conversion & import spec error 1

Top