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.
 

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 CSV Type Conversion Failure 3
Import Trailing Spaces 8
CSV import error only with code 1
Add .csv File Name When Importing Multiple Files Into a Table 0
Import & export tables based on table data and docmd 14
Import Specs Changed "Magically" in Midst of Loading Sequence 3
Decimal Truncation Issue upon Import - Access 2007 1

Back
Top