The articles in this section describe Excel data import to SQL Server techniques and contain working examples.
- Excel Import to SQL Server using SSIS
- Excel Import to SQL Server using Linked Servers
- Excel Import to SQL Server using Distributed Queries
- Excel Import to SQL Server using OleDB-SQL Utility
All techniques allow importing data from Microsoft Excel 2003 and 2007 files.
You can use SQL Server Integration Services if you have SQL Server Standard or higher as SQL Server Express Edition not allows saving an SSIS package.
Look the last article. This is an easy way to import Excel data using command line utilities for any SQL Server editions.
Linked Servers and Distributed Queries are the techniques that allow using the SELECT statement in SQL Server to get the data from the Excel workbooks.
You will find useful tips and working examples for each technique to save your time.