Re: converting from long to double
- From: MGFoster <me@xxxxxxxxxxx>
- Date: Tue, 04 Dec 2007 14:41:39 -0800
sparks wrote:
After changing all the variables in a table from long to double.
you get 9.1====becomes==== 9.19999980926514
ok I checked microsoft and they had a workaround.
export the values to excel...then import them back into the new table.
well I tried that and get the same thing.
is there a work around for the work around LOL
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
9.1 would not "fit" in a Long column. Longs are large Integers (no
decimals). So my guess is that you originally had a TEXT column w/
decimal numbers as the values.
One tedious way to change the text values to Double values would be to
create a new table that has the same columns as the original table,
except change the numbers Text column to a Double data type. Then
import all the rows from the original table into the new table using an
Append query - like this (say colC is the converting column):
INSERT INTO <new table name> (colA, colB, colC)
SELECT colA, colB, Val(colC)
FROM <old table name>
Then delete the old table (or rename it for safety's sake) and name the
new table w/ the old table's name.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBR1XXnoechKqOuFEgEQL/XwCdE8LrW3ykVnbBMaYa8KigAmU4MeIAn1Q+
5lTUXLNy7JerrkiISfMXeAHS
=qGRG
-----END PGP SIGNATURE-----
.
- References:
- converting from long to double
- From: sparks
- converting from long to double
- Prev by Date: Difficulty in Make-Table query, TickBox transfer in to binary value
- Next by Date: ? Syntax problem in SQL Delete
- Previous by thread: converting from long to double
- Next by thread: Re: converting from long to double
- Index(es):
Relevant Pages
|
