hi, i got a problem retrieving numeric data from SQL Server 2000. The column is defined as Decimal type, and im accessing by OLEDB connection using “*lsxlc”. Everything looks fine in executing command, but when i try to see the data, always looks as 0. Any idea for helping me?
Subject: Problem retrieving numeric data from SQL Server using OLEBD
you might try placing a couple of print statements in the code - especially after the numeric data is retrieved - to see what type if data is coming inalso be sure that values in the code are numeric data type