Insert data into file excel ?

[Thangnc]

I had one file template type "file_1.xls". I need open file this and insert data in sheet of file. But at present because of me haven't been processed. Can you help me and give a examples to me ?

[barkanb]

You can use ODBC connection for that. By using Transact SQL command like UPDATE or INSERT you will be able to print in Excel file. You can search web for an appropriate ODBC connection to a file code. B.B.

[barkanb]

http://www.codeproject.com/database/excel_odbc.asp[^] Check out the link.. You should know a little SQL query.