Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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