|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Wednesday, August 08, 2012 5:20 PM
Points: 40,
Visits: 2,465
|
|
| Yes, one would think there should be a better solution however, Microsoft have not released 64-bit versions of ACE and their suggestion is to use SSIS when accessing external data. Which is not appropirate for my app, in the mean time the 32-bit / 64-bit solution... while clunky works fine.
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Tuesday, February 12, 2013 12:40 PM
Points: 10,
Visits: 193
|
|
I just had a case open with them on this issue and their solution was to install a 32 bit instance of SQL and via linked server call a proc to run the openrowset. I guess I should know better, but I was shocked M.S. pulled this one.
After I questioned the suport staff a bit they researched and said that their would be 64 bit text/excel drivers at some point. The next version of Office is supposed to come in both 32 and 64 bit flavors, so I guess we should get 64 bit drivers as it approaches or at least when it is released.
FisherDad
|
|
|
|