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. 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!
 
K

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.
 

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
Import Trailing Spaces 8
Import CSV Type Conversion Failure 3
Import Specs Changed "Magically" in Midst of Loading Sequence 3
CSV import error only with code 1
Import & export tables based on table data and docmd 14
import csv conversion & import spec error 1
CSV Import with duplicate field names 3

Top