How to Import data From Excel File to Sql Server 2008 Using PL-SQL?

Answer 1

First Create Schema for your Temp table in Sql Server.

Create table Temp
{
[Column1] as Varchar(200),
[Column2] as Varchar(200),
[Column3] as varchar(200),
[Column4] as varchar(200)
}

After that Set each Column Data Type varchar because while importing excel File we don’t want errors related to data type conversions.

After that write the following Query.

INSERT INTO [tblTemp]
                       ([Column1], [Column2], [Column3], [Column4])

SELECT    A.[Column1], A.[Column2], A.[Column3], A.[Column4]
FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\Excel.xls;HDR=YES', 'select * from Sheet') AS A;