I just have to insert data to the existing tables. Let's say i have 10 tables and each table is having one-one record. Now, I want to import ten-ten records...

Alistair Potts, Thanks for the info.. but, it will not work. I need to import 10 sheets from workbook to SQL server management studio 2008.

I tried with one sheet. I...

I tried importing it as Excel 97/2003 .xls format (instead of 2007) and it is failing.

Also I tried to follow as per the below link for SQL 2008 and found...