Best way to Import Excel .xls file data into SQLserver Database?

Question

using ASP.Net with C#. I used OLEDB / ODBC but have error ISAM uninstallable or File has no permissions.

Answer 1

You can use any of the following techniques:

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



Refer to the following site for details:

http://support.microsoft.com/?kbid=321686

Answer 2

Microsoft SQL Server 2005 Integration Services (SSIS)

Answer 3

Microsoft SQL Server's DTS Import / Export Wizard