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.
Pingback: Excel via Linked Servers « TroubleshootingSQL
There are some things to know if you want to use OPENROWSET, see here http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/MSSQLServer/ace