--
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.
Solution for the QlikView, Biztalk, DotNet and MSBI real time development problems
Search This Blog
Tuesday, May 26, 2009
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Qlikview developer, Designer and admin interview questions (Qlikview developer, Designer and admin FAQ’S) 1. Difference between Set ...
-
The typical way of testing WCF services is to create a test project, add a service reference to the project, and then write a test agains...
-
@foreach (var item in Model), Object reference not set to an instance of an object in MVC Razor ViewIndex.cshtml @model IEnumerable <RazorEngineMVC.Models. User > @{ ViewBag.Title = "Index" ; } < h2 &...
-
.Net Integration with Bill Desk Payment Gateway Introduction: Now-a-days online shopping websites has become very popular, and to h...
-
. In the ASP.NET runtime the life cycle of a page is marked by a series of events. In ASP.NET 1.x, based on user interaction a page request ...
2 comments:
Challa, Good information, You can sell this code for 40$.
Post a Comment