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:
- Click Start.
- Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
- The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
- Type or copy paste the below command line into it without quotes:
- "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?
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.