Export Specifications Rounding Problem

[Tom]

I have been exporting to Fixed Width using the same specifications for
years yet yesterday for whatever reason during the export it is
rounding any decimal numbers to whole numbers.

I have created a workaround for now by changing the field in the table
to text and creating a new specification (which changes the
MSysIMEXColumns Datatype from 7 to 10) but only want to keep this
temporarily. After the spec is created the field can go back to
number and it works fine. However I am sure I won't remember to do
this in the future.

The same DB on a different machine works as expected.

 

[Joe Fallon]

Write a query, use Format on the field and export the query.

 

[tom]

Tried that and it still failed, also tried using cstr(). It appears the only
solution was to change the field in the table to TEXT re-create the spec,
change the field back to NUMBER and then re-export it.

Strange behavior.