If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem importing decimal places
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. |
#2
|
|||
|
|||
"=?Utf-8?B?Um9iZXJ0TQ==?=" wrote in
: I've got the table set up to hold six decimal places, but it still rounds off. 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 |
#3
|
|||
|
|||
Tim Ferguson wrote: I've got the table set up to hold six decimal places, but it still rounds off. 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. They could actually mean DECIMAL with a scale of 6 e.g. ALTER TABLE MyTable ADD price_euros DECIMAL(15, 6) NOT NULL |
#4
|
|||
|
|||
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. -- Regards Jeff Boyce Office/Access MVP wrote in message oups.com... Tim Ferguson wrote: I've got the table set up to hold six decimal places, but it still rounds off. 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. They could actually mean DECIMAL with a scale of 6 e.g. ALTER TABLE MyTable ADD price_euros DECIMAL(15, 6) NOT NULL |
#5
|
|||
|
|||
Jeff Boyce wrote: 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. 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...b;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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
change decimal places in subform | kabaka | General Discussion | 9 | August 24th, 2005 03:49 PM |
Access 2003 calculated fields and decimal places | daveyboy300 | General Discussion | 3 | July 30th, 2005 12:46 PM |
How to set decimal places for a column in the report | Karen Middleton | Running & Setting Up Queries | 2 | December 13th, 2004 06:59 PM |
fixed decimal places | Michael | New Users | 2 | August 26th, 2004 05:58 PM |
decimal places | andrew | Database Design | 1 | July 27th, 2004 11:17 PM |