Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
satish439
Starting Member
6 Posts |
 Posted - 2010-02-11 : 08:18:34
|
| Hi Experts, I created a package to import data from excel 2007 file and dump into db table. I used 'Microsoft Office 12.0 Access Database Engine OLEDB Provider' for connecting my source according to the requirement.This works fine in my local system. But when i deployed the package into main server, it gives the following error message:The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machineI have installed MS-Office 2007 and its Data connectivity components from below site:http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=enAfter installing this i restarted sql server services and the machine also. Then it seemed to work well yesterday. But when i run it today same problem still exists. I again restarted services and machine, though my problem is not solved.Please give your valuable thoughts on this. Its urgent for me. |
|
|
|
|
|
'Microsoft.ACE.OLEDB.12.0' provider error