• there is a very similar issue when adding linked servers for Excel;

    I tripped over this before , where Office 32 bit was installed on my server, and you get in a catch-22 where you cannot install the 64 bit ACE drivers, and even if you uninstall Office 32, some bits are left behind that prevent the 64 bit version of office, or the ACE drivers from being installed.

    fortunately, there is a solution!

    install the AccessDatabaseEngine_x64.exe from microsoft:

    http://www.microsoft.com/en-us/download/details.aspx?id=13255

    The trick is a simple command parameter: make sure you open an Administrative command prompt window, and run it with the c:\Downloads\AccessDatabaseEngine_x64.exe /passive

    command line flag;

    this will force the install of the drivers, even if you have 32 bit office installed;

    otherwise you get some error about 32 bit Office preventing the install.

    From there you should be good to go!

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!