#Use ms office 32bit or 64bit? install
#Use ms office 32bit or 64bit? 64 Bit
#Use ms office 32bit or 64bit? drivers
#Use ms office 32bit or 64bit? driver

Then we have to somehow determine which version of the ACE driver is installed so we know which version (32 or 64 bit) of our application to install. The fact that they cannot forces us to compile two different versions of our application one specifically for x86 platform and one for ењ†4 platform. There are a lot of information on this topic: Why it is not possible to do this directly is a big question.

Well, the issue is to make the 64-bit version of Microsoft ACE OLEDB Provider work with the 32-bit Office.

#Use ms office 32bit or 64bit? install

But I tried to install the 64 bits driver, but it is giving me an installation errorвЂ¦ - The previous KB article explains the cause and provide the solution, you can refer to it. That makes no sense to me, because the goal is to connect to the 32 bits MS Access databaseвЂ¦ - You need to install the 64-bit version of вЂњMicrosoft ACE OLEDB ProviderвЂќ to connect to an Access file (32-bit or 64-bit) from SQL Server. Thanks for your answer, but I when I install the AccessDatabaseEngine_X64.exe I get the following errorВ (picture 1) - Please refer to this KB article: /kb/2269468 - The article in the link in your last message tells to de-install all Office 32 bits products. Since there is no 64-bit Jet, you need download and install the 64-bit version of В«Microsoft Access Database Engine 2010 RedistributableВ». An additional installation of a SQL Server 32 bits, only providing the link to MS Access would be the only option then.

#Use ms office 32bit or 64bit? 64 Bit

It is also not an option to de-install the existing SQL Server 64 bit and install the 32 bits version, of course. The MS Access database is a production environment at the customers site, and it is not an option for me to de-install it and install a 64 bits version.

LetвЂ™s have a look at the question a person has raised on MSDN: Should I choose between the 64-bit or 32-bit version of MS Office and 64-bit or 32-bit version of SQL Server? Uninstalling one version and installing another is not a flexible solution. If 32-bit Office were not installed on the computer, then you would not get this warning. We get the following error during the installation process: Install 64-bit provider, which is available for download at Microsoft Access Database Engine 2010 Redistributable. Thus, an attempt to use Excel or Access with SQL Server linked servers, as described in the documentation, will cause the following error:Д¬annot create an instance of OLE DB provider В«.12.0В» for linked serverвЂ¦

#Use ms office 32bit or 64bit? drivers

However, in this case, using Excel or Access with SQL Server linked servers may be a challenge because drivers are 32-bit.В There are no providers available for MS Office, although I have one installed on my PC. A typical user is unlikely to install a database server, while it is normal for a developer to have a 64-bit SQL Server on a 64-bit machine with 32-bit MS Office.

It had been until the 64-bit architecture stopped being something from the hi-end class and came to the developer and user laptops. You can use the Linked Server mechanism, which allows you to see any ODBC / OLE DB-reachable object in the form of a table (a collection of tables) or the result of an ad hoc query. Another way is to create a simple ADO.NET app. You can utilize Integration Services (former DTS) or import and export wizard, which is the same under the hood. There are many ways to accomplish this task. What could be simpler than to get data from an Excel table in SQL Server?