Jet Provider for x64


All those who have blogged about the non-availability of x64 version of Jet (including me :)) would now have to eat their blog posts or at least publish addendums stating that there is now a x64 version of Jet Provider (oops it’s now called ACE) with the advent of Office 2010.

If you had an application which imports data from an Excel sheet into a SQL Server database table using a Jet Provider, then there are chances that you either moved to SSIS packages or kept on using a 32-bit version of SQL Server. Well now with Office 2010, you have the option of using the ACE provider for connecting 64-bit Office files.

Make sure that you read the end user agreement before you migrate everything off to use Office 2010 Data Access components.

Read more about it here: http://blogs.msdn.com/psssql/archive/2010/01/21/how-to-get-a-x64-version-of-jet.aspx

Addedum: April 4th, 2010. After my colleague, Evan pointed out the server side support policy for ACE.

Disclaimer: The ACE redistributable link does mention the following:

The Access Database Engine 2010 Redistributable is not intended:

  • As a replacement for the Jet OLEDB Provider in server-side applications.
  • To be used within a service program or web application that relies on a Windows service.
Advertisements