question

priyanshurai2000 avatar image
priyanshurai2000 asked

read data from sheets of multiple excel file in a folder

I want to read data from specific sheet of multiple excel file in one folder into a SQL table, Data structure is same in all the sheets but workbook name is different. I want SQL queries not SSIS package. PS- I am using SQL express. Please suggest if there is any additional settings are required. Please help
tsqlssis excel
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
H_G_H avatar image
H_G_H answered
This may help insert INTO tbexcel SELECT * FROM OPENROWSET(‘Microsoft.Jet.OLEDB.4.0′, ‘Excel 8.0;Database=\\excel.xls’, ‘SELECT * FROM [Sheet1$]’) Good Luck H G
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.