Post reply

linked table from sqql server200 into access 97, problem with numeric data

  • March 21, 2007 at 7:39 am

    #369916

    I have a table in Sql Server 2000 with a numeric field, actually float.

    I use this table in an access 97 application, when trying to insert rounded data I receive an error talking something like "decimal precision it's too small yo receive the numeric value you tried to insert"

    The code ( in access )is this:

    INSERT INTO dbo_Celp (ValorTotal)

    SELECT val(format(CxCH.Cantidad*CxCH.Valor,"############")) AS ValorTotal

    FROM xxx

    WHERE ...

    Any idea?

    Muchas Gracias

    Luis Aguayo

  • March 21, 2007 at 7:58 am

    #696149

    Luis, check the BOL for the value range for FLOAT (

    - 1.79E+308 to -2.23E-308, 0 and 2.23E-308 to 1.79E+308

    ), then review the source data to find out if they are in the range. It may sound ridiculus, but we had a recent encounter with this situation passing floats from SAS to SQL.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply