Hi There: Very first time in your forum. I have a VB.net project that takes data from SQL server and puts them in MS Excel as reports. The SQL stored procedure is used to generate .Net dataset. In SQl, I take data from a view where I declare all my data as integer. In SQL stored procedure , I declare them as bigint. When I am running the Stored procedure from SQL Query analyzer, I am getting the currect results. But when I am running my .net program, I am getting wrong numbers as shown in my excel sheet. I saw the dataset in .net is created where the data are declared as long. So before putting into excel sheet from vb.net the result is(say for 1 field) 103,456,566. But in Excel sheet its showing as103,456,560. So its a bit less in Excel now. I tried to change the data type in my SQL stored procedure as real, float and each time its giving me quite different results. Only declaring bigint in SQl gives me the currect result in SQL side but again wrong in Excel.
Thanks in advance
Abeed
Thanks in advance
Abeed