Exporting/Importing Numerical data

  • Thread starter Thread starter Sean Evanovich
  • Start date Start date
S

Sean Evanovich

I have a "local" db that exports a table that includes a
number field that is defined as having 4 decimal places.
When I created the export specification (by chosing the
table contents and then "export") all of the numbers only
had 2 significant digits (e.g. 11.11) but when I recently
processed some records I have numbers that look like
this: 11.0005.

When I use the export spec that I created (uses the
default specifications that access povides) my field
looks like this 11.00...I lose the 05.

Is there a way to correct this?

I export this table as a text file, ftp it to where I
keep the "master" copy of the database, and then import
the records. I currently use the same specification to do
both export and import (since the tables are the same).

Any help would be appreciated!!!
 
Just and FYI...

I figured out how to do it...if anybody wants an
explanation respond to this and I will email you...
 
Back
Top