question

Gangadhar.marisetti avatar image
Gangadhar.marisetti asked

how can i load the data from multiple excel sheets(like sheet1,sheet2,sheet3......) in asingle excel file to sql server table?

for example i have one excel file called loan details in that file i have four sheets like sheet1, sheet2,sheet3,sheet4 i want to load all 4 sheets data in to a table so plz help me thank you.
ssisexcelimport-data
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

·
Fatherjack avatar image
Fatherjack answered
SSIS will be the best tool for this. Take a look at https://www.simple-talk.com/sql/ssis/moving-data-from-excel-to-sql-server---10-steps-to-follow/ and the SSIS series from @mrs_fatherjack https://www.simple-talk.com/author/annette-allen-/. There is also content in Books Online / MSDN http://msdn.microsoft.com/en-us/library/ms141026.aspx.
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.