This is driving me nuts!!

[RobertM]

I'm trying to paste data into a table. The values are #'s such as 108.577645.
When I paste it over it comes out 108.577640. I've got the table set up to
hold six decimal places, but it still rounds off. Any suggestions.

 

[Marshall Barton]

I'm trying to paste data into a table. The values are #'s such as 108.577645.
When I paste it over it comes out 108.577640. I've got the table set up to
hold six decimal places, but it still rounds off. Any suggestions.

It sounds like the field size is Single, which is rather
limited. You probably need to change it to Double.

 

[Dennis]

I have just tried it and it pastes OK. My number was set to Double with 6
decimal places. What number type is yours ?

 

[peregenem]

It sounds like the field size is Single, which is rather
limited. You probably need to change it to Double.

It sound like the data is DECMIAL(n, 6) to me e.g.

SELECT TYPENAME(108.577645)

returns 'Decimal'.

Exmaple:

ALTER TABLE MyTable ADD price_euros DECIMAL(15, 6)