- SQL Server
- SQL Azure
- SQLCMD
- SQL Server CE
- Adding Dates
- Create Database
- Creating and Using a Number Table
- Database Mail
- Linked Server
- SQL Server - Aggrigration of strings using TSQL
- SQL Server - IDENTITY
- SQL Server - MERGE Example
- SQL Server - Reading information from an XML document using OPENXML
- SQL Server - Resource governor
- SQL Server - User Defined Table Types
- SQL Server - Using Row Constructors
- SQL Server - Using the PIVOT operator
- SQL Server - Using the UNPIVOT Operator
- SQL Server - statistics
- SQL Server Backup
- SQL Server Common Table Expressions (CTEs)
- SQL Server DATE calculations
- SQL Server Mirroring
- SQL Server OPENDATASOURCE
- SQL Server OPENROWSET
- SQL Server Service Broker
- SQL Server Sparse Columns and Column Sets
- SQL Server Window Functions
- SQL Server XML Data Type Operations
- SQL Server XML Schema Collections
- Truncate TRN Log in SQL Server 2005/2000
SQL Server - Reading information from an EXCEL file using OPENROWSET
Connecting from SQL Server to an Excel File using OPENROWSET
-- Excel File: c:\data.xls
-- Worksheet : Sheet1
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=c:\data.xls', [Sheet1$])
Cant find the page you are looking for?
Help us to improve by adding the content that you are looking for.
Leave a feedback
We look forward to hear your comments and feedback.
Help us to improve by adding the content that you are looking for.
Leave a feedback
We look forward to hear your comments and feedback.
- 3115 reads
Syndicate
Popular content
Today's:
- Search for a cheat sheet
- Working with GridView - Changing cell/row/text color based on condition
- Vb.NET - IsDate() to check for valid date input validation
- ASP.NET
- SQL Server OPENROWSET
- Cant find what you are looking for?
- SQL Server Cheat Sheet - FULL Backup
- Javascript - Dropdownlist validation
- VB.NET - CDate to convert a valid date to MM/DD/YYYY format
- JavaScript - Input validation check for integer and float values
- SQL Server OPENDATASOURCE
- ASP.NET - Download file to client browser
- SQL Server Database Mirroring - Working with Mirroring Related DMVs
- SQL Server - statistics
- SQL Server - User Defined Table Types
- VB.NET - Add Rows and Columns to a DataGrid
- JQuery - To fade-in fade-out blinking of the text
- Vb.NET - To Ping another Computer
- SQLCMD
- JavaScript - Working with dropdownlist
- SQL Server XML Schema Collections
- VB.NET - Working with DateAdd()
- VB.NET - Cheat sheet for Datediff()
- SQL Server XML Data Type Operations
- Implementing MemCache in ASP.NET
- VB.NET - Concatenate Multiple Files into single File
- MOSS 2007 - Get Users From SharePoint Group
- Working with ASP.NET GridView binding using List , ClientIDMode in ASP.NET4
- Working with PING in VB.NET
- ASP.NET4 SEO Features
All time:
About the author
