Dears, I'm trying to importing excel sheet using SSIS, I noticed that all cells that contains formula (C1 = C1+C2) comes as null. Is there is a way to overcome this problem.

Hi, Do you use SQL Server as the destination? If not, please tell us which destination you use. I use SQL Server as the destination and create a table that includes a float column to hold the data. Based on my test, if the cell only includes the formula not the calculated result, then that cell’s value will be saved as null value. So please make sure that cell holds the calculated results. For example: A 1 1 2 2 3 Type formula “=(A1+A2)” in the cell A3, then the result “3” will be shown in the A3. In addition, I found your formula is C1=C1+C2 , as far as I know, Excel cell can't directly call itself.If you can, please send your Excel file into the following email, then we can do a further test.sqltnsp@microsoft.com Please feel free to let me know if I’ve misunderstood anything.Please remember to mark the replies as answers if they help and unmark them if they provide no help. Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Add a data viewer and verify whether you are seening data correctly. I just check this. I can see the data correctly and well as there are wrting to the SQL Serve with out any issueBlog: http://dineshasanka.spaces.live.com

Add a data viewer and verify whether you are seening data correctly. I just check this. I can see the data correctly and well as there are wrting to the SQL Serve with out any issue Blog: http://dineshasanka.spaces.live.com Tareq Ali, I have also tried the same on SSIS2008 + Excel2007 and its working fine. Thanks-Let us TRY this | http://quest4gen.blogspot.com/

I tried with SSIS 2008 + Excel 2003 and I can't see why it should not work as it is reaing the content of the cell not the formula.Blog: http://dineshasanka.spaces.live.com

Zongqing Li I sent the sheet to sqltnsp@microsoft.com

Hi Tareq, I tested your Excel and import them into SQL Server, but I can’t reproduce your issue. The calculated values were still imported into database. So I suppose this issue is caused by the SSIS tool. Could you tell me the version of your SSIS? My environment: SQL Server 2008 +SP1. Please try to install SP1 if not. Please remember to mark the replies as answers if they help and unmark them if they provide no help. Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hi, I have the same problem. When I try to import excel file to the database. Even if the Number Type of the column is "Text". When the Number Type of the calculated column is set to "General" -everything works fine. But i need to use Text format because of incorrect import of text like this : "6.3" - it recognized as real number, and i'll see in the database something like this "6.30000000000000" in the nvarchar column. That's why i changed the Number Type to "Text", but now I can't load columns containing formulas. They are became NULL during loading. I use Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 Thank you!