Problem trying to Import decimals

[Monti2]

I am trying to import a .csv file which has several numeric fields containing values with decimal places.

When I import the file using:

-"Get External Data / Import" (without using a SPEC)

The decimals are imported into the table correctly

-"Get External Data / Import" (using a SPEC)

Values are rounded to nearest whole number on import

-"Transfer Text / Import Delimited" within a Macro (using a SPEC)

Values are rounded to nearest whole number on import


Within the table my value field is set up as follows:

Field Size: Double
Decimal Places: Auto
All other criteria: left as deault


As I have several files like this which I will need to import on a regular basis I would like to incorporate it within a macro

Any advice on how to achieve the import of values (with decimals) would be appreciated.

 

[boblarson]

You'd better go back and make sure that the Import Specification is set up as Double. It might be set as Integer.

 

[Monti2]

Indeed the data fields within the spec were set to Integer, and having now set them to Double the Decimals import correctly.

Many thanks.