Import from XLS into SQL Server

Importing from an XLS to SQL Server – This can be accomplished several ways mentioned below. We can choose an option befitting the environment and requirement we are looking for.

SQL Server Data Transformation Services (DTS)

Microsoft SQL Server 2005 Integration Services (SSIS)

SQL Server linked servers

SQL Server distributed queries

ActiveX Data Objects (ADO) and the Microsoft OLE DB Provider for SQL Server

ADO and the Microsoft OLE DB Provider for Jet 4.0

 

You can refer to https://support.microsoft.com/kb/321686 for detailed view of these methods