Problem importing decimal places

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to get data into a table. The values are #'s such as 108.577645.
When I paste it over it comes out 108.577650. I've also tried to import this
data from a text file as well as from excel without any luck. I've got the
table set up to
hold six decimal places, but it still rounds off. I'm dealing with a
database that is dependent on imported data from another system. Any
suggestions.
 
I've got the table set up to
hold six decimal places, but it still rounds off.
Click to expand...

What "size" is the numeric field set to? A Double should handle this
precision easily enough, but a Single may be rounding at about this level.

B Wishes


Tim F
 
Tim said:
What "size" is the numeric field set to? A Double should handle this
precision easily enough, but a Single may be rounding at about this level.
Click to expand...

They could actually mean DECIMAL with a scale of 6 e.g.

ALTER TABLE MyTable ADD price_euros DECIMAL(15, 6) NOT NULL
 
This may not apply in the circumstances...

I seem to recall seeing that there are issues with sorting (and other
topics) in the use of the DECIMAL data type.
 
Jeff said:
This may not apply in the circumstances...

I seem to recall seeing that there are issues with sorting (and other
topics) in the use of the DECIMAL data type.
Click to expand...

BUG: You may notice an incorrect sorted order when you sort the
negative decimal values in descending order in Access
http://support.microsoft.com/default.aspx?scid=kb;en-us;837148

It's not 'critcal' because sorting can be successfully performed
elsewhere, notably using a recordset's Sort property. Just as well
because

SELECT TYPENAME(108.577645)

returns 'Decimal' i.e. this data type is used natively by the data
engine!
 
Back
Top