Question: how to import excel data in sql server 2008 r2?
Answer: Step 1: Select Destination Database where you would like to Import Excel 2007 Sheet. ... 
Step 2: Select “Microsoft Office 12.0 Access Database Engine OLE DB Provider” from data source selection drop down. ... 
Step 3: Properties dialog box appears.