Unanswered: create SSIS Package to import Excel to SQL DB
I am trying to import data from Excel to SQL DB. I have problem understading of transfering data. please guide me how to do this. There are several tabs in excel file and need to transfer that data in to one table.
Importing from Excel is going to be mess if the data is not in tabular format.
Even then, Excel is notorious for allowing users to mess around with the layout and cell contents, so you will need good error trapping on your import process.
You could try creating these different data pieces as named ranges on the spreadsheet, but then you will need to make sure every spreadsheet you import this way uses those same named ranges.
If it's not practically useful, then it's practically useless.