Importing Data Common Problems and Fixes
1. Driver Error importing from Excel
This error occurs when you try to import an Excel spreadsheet using the Excel driver into SQL Server
The article to fix this error is here
This will guide you to install the 2007 Office System Driver: Data Connectivity Components – which are available here
Install the Access Database Engine Driver this should fix your problem.