Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  export excel formula from sql server

Author  Topic  kamel Starting Member 1 Post Posted - 2009-09-22 : 07:37:05 hi, i've a SQLSERVER table with a formula like =A1+B1 When export this formula with openrowset: INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\test.xls;', 'SELECT dato, formula, op1, op2 FROM [Foglio1$]') SELECT dato, formula, op1, op2 FROM test.alex2 the value of formula is not refresh and when open the xls files i see =A1+B1, but when press F2 the result appear. I would import in sql server the RESULT of the formula, but the statement: SELECT * into test.alex3 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=c:\test.xls', [Foglio1$]) copy the formula and not the value! Thanks