There is now a 64 bit JET driver available for SQL-Server 64 bit; however, you must be extra careful before installing it because it is not compatible with the 32 bit version: you cannot install it on a machine which has already the 32 bit driver installed.
So, if you have already a copy of Office/Access 32 bit installed on this machine, you must first remove them before installing this 64 bit driver.
You can find this driver for download at:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en
For Access and Excel, the 'Ad Hoc Distributed Queries' option must be set to
ON and, in come case, the N'AllowInProcess' and N'DynamicParameters' must
also be set, see:
http://msdnrss.thecoderblogs.com/2010/06/04/blog-post-accessing-excel-files-on-a-x64-machine/
A better option would to install a copy of SQL-Server Express 32 bit and use it as a proxy to do your stuff. See for example:
http://information-management-enabled.blogspot.com/2005/11/access-database-from-sql-200564.html
The above is a complex generic solution but in your case, probably that you will be able to whip up something much more simpler.
Other possibilities would be to use any other external client like SSIS or even ASP to etablish a data transfert between your SQL-Server 64 bit and Excel. In fact, you could even do this directly from Excel by using the ADO objects with VBA code.
Sylvain Lafontaine, ing.
MVP - Access
Blog/web site:
http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server (French)
