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

2 thoughts on “Jet Provider for x64

  1. Pingback: Excel via Linked Servers « TroubleshootingSQL

It is always good to hear from you! :)

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s