-
I have following excel sheet and I
want to import all data into temp SQL table.
-
SQL Server OpenRowSet command can
do data transformation easily. You can do that with following simple query in
SQL.
·
I created simple temp table in SQL
and import all rows from excel sheet into temp table.
INSERT
INTO [dbo].[#tblImport]
SELECT
Code, BasicSalary, GrossSalary
FROM
OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel12.0;HDR=YES;Database=D:\Salary_Register_offshore.xlsx', 'SELECT * FROM [Sheet1$]');
Output
