Question: how to import excel file in sql server 2008 r2?
Answer: You can download from here. Step 1: Select Destination Database where you would like to Import Excel 2007 Sheet. Right click database > Tasks > Select Import data… as shown in following figure. Step 2: Select “Microsoft Office 12.0 Access Database Engine OLE DB Provider” from data source selection drop down.