DaFou
asked on
How to work with excel from TSQL
Hi All,
I'd like a workign example on how to, in TSQL in SQL server 2000, open an excel workbook 'c:\tester.xls'. update field "value1" and "value2" from the first worksheet.
run the calculate method
and read the value from the "result" field
regards
I'd like a workign example on how to, in TSQL in SQL server 2000, open an excel workbook 'c:\tester.xls'. update field "value1" and "value2" from the first worksheet.
run the calculate method
and read the value from the "result" field
regards
you can use OPenQuery, OpenDataSource...function to access excel.csv,mdb from t-SQL.
ASKER
no good, i am looking to work with the excel workbook not only import data from it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
how can i have excel do calculations using the OPENDATASOURCE and work with the results in TSQL?