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
LVL 2
DaFouAsked:
Who is Participating?
 
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
Try to create Linked Server for the excel then you will be able to work on worksheet as like u r working with the linked server for the database.

0
 
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
you can use OPenQuery, OpenDataSource...function to access excel.csv,mdb from t-SQL.
0
 
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
DaFouAuthor Commented:
no good, i am looking to work with the excel workbook not only import data from it.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
DaFouAuthor Commented:
how can i have excel do calculations using the OPENDATASOURCE and work with the results in TSQL?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.