I have a SQL Server 2014 virtual machine. It is a 64 bit version of SQL Server or a 64 bit Windows Server. The SQL Server software was installed before I was hired by the Sysadmin. He choose to have the 32 bit drivers for Access (Office) installed. We’ve talked about it, he claims he did it because we are using a 32 bit version of Office 2010.
Anyway, I uninstalled the AccessRuntime_x32 and installed AccessRuntime_x64. I’ve downloaded both the 2010 and 2013 versions off the Microsoft Website. I’ve restarted SQL Server, I’ve even rebooted the whole server. Yet I still can’t export out more than 64,000 rows of data for Excel nor can I choose a new version of Microsoft Excel past 2007. What am I missing?