This is a blog which will post useful infomation about fixing computer errors. To help people troubleshoot errors, speed up computers and share good apps.

3/20/2016

64 bit provider for Microsoft ACE OLEDB [Solved]

64 bit provider for Microsoft ACE OLEDB

Hi,
When I am trying to import Excel file data to SQL Server 2005 express Advance, it shows following Error
 
cannot initialize the data source object of OLE DB provider ""Microsoft.ACE.OLEDB.12.0" for linked server "(null)" on 64-bit machine.
 
already Executed the  following commands but still the above error occurs.
 

USE [master]
GO
EXEC master .
dbo.
sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1
GO
EXEC master .
dbo.
sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 1
GO

 
can any one suggest how to proceed further ?
 
king regds
 
ETK Valsan

Solutions to the Problem 64 bit provider for Microsoft ACE OLEDB

Download SmartPCFixer for Free Now

Use the System File Checker tool to repair corrupted or missing system files:

  1. Click Start.
  2. Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
  3. The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
  4. Type or copy paste the below command line into it without quotes:
  5. "Sfc /scannow"

Another Safe way to Fix the Problem: 64 bit provider for Microsoft ACE OLEDB:

 

 

How to Fix 64 bit provider for Microsoft ACE OLEDB with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will scan your system. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed


Related: How to Fix 3371 Errors in Windows XP,7,8&8.1?,Repair Corrupt Cab Files Error - How to Fix,Skchui.dll Error - How to Fix,Symantec Antivirus Slows Down Computer Error - How to Resolve,Error Windows Xp System Restore Incomplete Fix Solution,How to Fix - After updating from Internet Explorer 6 to Internet Explorer 9, my Favorites are lost?,How to Fix - Combination Stacked-Clustered Chart in Excel - Align data with horizontal tick marks?,Solution to Error: Macro to search and copy rows to different sheets based on cell value,Need solution to this problem in order to stop Vista from beeping.__"Your version of Microsoft Deprecated DLL Components isn't compatible with this version of Windows",Server Error in '/' Application.Site also runtime error [Solved]
Read More: ,2 msn.com site,2007 Performance Issue / Very slow saves to network share,Can I use my HP D110A web service printer as a proxy server?,can i use a zoom 56k v.92/v.90 modem with 64b dileup? netzero said i might have the rong modem?,Can I downgrade to win 32-bit?
Share:

0 comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Sample Text

Copyright © Fix Your PC Errors & Speed Up Your PC | Powered by Blogger Design by ronangelo | Blogger Theme by NewBloggerThemes.com