How to import data form excel with multiple worksheets to a single sql server table?
Posted on 2013-06-03
I have an excel 2010 with multiple tabs(around 10 tabs) in it with each tab containing the data.
I am using Microsoft SQL server Management Studio 2008 R2.
I would like to import the data from the excel from all tabs into my single table in the database.
This is one time activity.
I could use import wizard and load only one tab or one worksheet in the excel one time.
I am forced to connect again to wizard to load the second tab (worksheet) in the excel.
When I map tow Sources(two worksheets in the same excel) and Destination as same table for both the sheets it is giving
error as " The sam destination table name is used more than once. All destination table names must be unique"
I have many worksheets in a single excel.
So Can you please let me know if the is there any way to load all in one table so that I can avoid every time opening the wizard.