Don't see the Microsoft.Jet provider in my new SQL Server 2008 R2 instance?
I believe that starting in 2008 R2 Jet was no longer included with the SQL Server install.  For R2 64 bit I believe you will need to download and install the Microsoft Access Database Engine Redistributable package found here.

This should install the necessary drivers for Office doc access from 64 bit SQL Server.