Perfrom following steps to Import Excel 2007 Sheet into SQL Server 2005.
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. Click on “Properties…" button as shown in figure.
Step 3: Properties dialog box appears.
Click on “Connection Tab" and Enter Excel 2007 file path in Data source text box.
Step 4: Click on “All Tab“
Select “Extended Properties" from given edit values and click on “Edit Value…" button
Step 5: Edit value dialog box appears.
Enter “Excel 12.0" in Property value textbox and click OK button
Step 6: Press Test Connection button to make sure everything is working good.
Finally press OK button.
After that you need to follow usual procedure to import excel sheet data into sql server. i.e. You need to click next and follow wizard instructions.
