How to load data from Multiple tabs in excel to different tables

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

vijayarani87.s SSC Eights! Points: 890 More actions · Answer 1

You need to do like this

INSERT INTO [dbo].[TableName] ( Column1 , Column2 )

SELECT *

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\TableName.xls',

'SELECT * FROM [Sheet1$]')

sqlstud SSCrazy Points: 2527 More actions · Answer 2

Thanks for the reply...

Forgot to mention..

Have to use SSIS Package to load the data

Regards

SqlStud