Question: how to import excel data into table in sql server 2008?
Answer: Chose the Sql Server instance and chose the database to which the excel to be imported. Select Copy data from one or more tables or views and click Next . Now select the sheets to be imported to Sql Server . Now the wizard imports the data from Excel to Sql Server and click Close .