Importing .csv file into Access 2007, Numbers Rounding Automatically

[ProgEvalJAA]

We have a .csv file we are trying to import into Access 2007.

One of the columns contains data with decimal places. When the column is imported into Access 2007, Access 2007 rounds the values (i.e. .500 to 0).

We've tried to change the field to double v. long integer format, but Access 2007 still rounded the value to 0.

We've tried to save the original file as .txt file and then import it, but that didn't seem to work either.

Any ideas?

 

[VRoscioli]

It is possible that the data is not being imported correctly and the field is being filled with the "Default Value" (which is 0 by default). Are all values "rounding" to zero or are they rounding to other integers as well?

If they are rounding to other integers, make sure that the decimal places field is set to something greater than zero.

Naturally, you will need to use the Single or Double datatype to hold decimals, since they are (by definition) not Integers. You also need to make sure this change is made *before* you try to import the data. (Access cannot take your integer data and magically reclaim the decimal places)

-V