469,570 Members | 1,709 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,570 developers. It's quick & easy.

upsizing data issues

Hi everyone,

I am using the Upsizing Tool in Access 2002 to upsize to SQLServer
2000. I am finding that the data type number (field size: double) when
upsized is turned into a float type. What is disconcerting is that the
upsizer appears to be adding data to the end of the value. What starts
off as 283.456 ends up as 283.4560000000003 or something like that.
Does anyone have any idea what might cause this and/or a way to stop
this from happening? When I link the table via ODBC and query for the
original value, I don't get a match. I have to query for the new
value. This is causing problems in my app. Also, when you view the
data in the linked table through Access, it appears unchanged, but when
you look at in Query Analyzer, it shows the changed value.

I have tried converting the data to decimal in some cases (after
upsizing) and that works fine, but I have about 200 fields of this type
and I will have to look at each one carefully to determine the proper
scale and precision in order to convert. Not looking forward to that
chore.

Thanks for any help,
Dave

Aug 22 '06 #1
0 1076

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Big Time | last post: by
1 post views Thread by Calum Chisholm | last post: by
2 posts views Thread by Big Time | last post: by
12 posts views Thread by John | last post: by
1 post views Thread by John | last post: by
3 posts views Thread by Devonish | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.