--
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:
Posts (Atom)
Popular Posts
-
.Net Integration with Bill Desk Payment Gateway Introduction: Now-a-days online shopping websites has become very popular, and to h...
-
MVC: Handling Multiple button submission from one view While developing any web applications we use to design lot more forms. Most of...
-
Error : Could not store transport type data for Receive Location 'EAISolutionReceiveRequestLocation' to config store. Prima...
-
· Include SET NOCOUNT ON statement. · Use schema name with object name. · Do not use the prefix “sp_” in t...
-
why use Windows Workflow Foundation? Microsoft has provided this foundation in order to simplify and enhance your .NET development. It is n...