Hi all,

Thanks for all your replies and time.

It seems the data in my table is in really bad shape. Though the solutions provided by you all is correct but somehow...

Hi Mark,

Thanks for your reply. I have already tried that with no luck... 🙁

Cheers,

Deepak

Hi Chandan,

Still no luck.. 🙁

I tried all the steps but getting the same old error.

OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used for distributed queries because the provider is configured to...

Hi Chandan,

Now that I have uninstalled all the components, I installed, I don't see any relevant "provider" when I try to link the excel file.

Even when I installed 32-Bit "Microsoft...

Sad again 🙁

Everything was looking fine until I opened a doc file. I received the attached error whenever I am trying to open any MS Office document (xlsx, docx etc.)

Any...

GOT IT :hehe: 😎 :w00t: 😛 😀 🙂

Got the tip from this link

http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/

Installed the "Microsoft Access Database Engine 2010 64 bit" (which I did earlier as well), but...

Hi Raj,

This is what I get when I ran sp_configure.

name : Ad Hoc Distributed Queries

minimum ...

Hi Anthony,

Sorry but still no luck. :crying:

I am about to kill myself now...

Thanks for your time and reply Raj but unfortunately got the same error

Msg 7308, Level 16, State 1, Line 1

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries...

Resolved....

Mailbox was full.

Microsoft should give more informative description.

Deepak

Thanks all for the replies 🙂

Regards,

Deepak

This does educate.. We should read it carefully before answering. Every word is a question.

Taught me though..

Thanks.