distributed queries are configured to run in single-threaded apartment mode
As Mark has mentioned in the comments, you are running into a bit-level mismatch between driver sets.  You will need to either install a 64-bit installation of Office (specifically Excel in this case) or install a 32-bit installation of SQL Server and import the data to that instance.