Click here to Skip to main content
15,887,027 members
Please Sign up or sign in to vote.
4.00/5 (2 votes)
See more:
Hi all,

I've recently started working with connecting to Excel 2010 files via the Microsoft.ACE.OLEDB.12.0 connection string.

But, what exactly is this "Microsoft.ACE.OLEDB.12.0" (dll, exe etc), and where can I find it's location on my computer?

I need to compare a few boxes to find out which of them has this provider available.
A search of my HDD did not provide any clues...



Thank you!
Posted

1 solution

Ona 64bit OS;

1) If 32bit is installed "ACEOLEDB.DLL" should exists here :

C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL

2) If 64bit is installed "ACEOLEDB.DLL" should exists here :

C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL

On a 32bit OS;

"ACEOLEDB.DLL" should exists here :

C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL

Also look at the latest driver : http://www.microsoft.com/en-in/download/details.aspx?id=13255[^]

Thanks!
 
Share this answer
 
Comments
JayantaChatterjee 26-Feb-13 13:08pm    
My 5

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900