Export Specifications Rounding Problem

  • Thread starter Thread starter Tom
  • Start date Start date
T

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.
 
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.
 
Back
Top