--
INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Book.xls;',
'SELECT Name, Date FROM [Sheet1$]')
SELECT [Name], GETDATE() FROM msdb.dbo.sysjobs
GO
To use OPENROWSET command
1. The Excel file must exist. You can use a file as template.
2. Enable OPENROWSET command from SQL Server 2005 Surface Area Configuration
utility.
Tuesday, May 26, 2009
Subscribe to:
Post Comments (Atom)
Popular Posts
-
MVC: Handling Multiple button submission from one view While developing any web applications we use to design lot more forms. Most of...
-
Object Dynamic Var Can able to store any kind of value, because object is the base class of all type in .net framework. Can able to s...
-
For MVC Interview Questions Part 1 refer below link: http://challadotnetfaq.blogspot.co.uk/2013/12/mvc-interview-questions-and-answers.ht...
-
//insert data into excel sheet private void btnSave_Click(object sender, EventArgs e) { using (OleDbConnection excelConnection = new O...
-
Here are some recommendations to help you to decide whether to use an interface or an abstract class to provide polymorphism for your compon...
2 comments:
Challa, Good information, You can sell this code for 40$.
Post a Comment