1

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?

1 Answer 1

0

When attempting to reproduce your issue, I received the following error:

the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine

I downloaded the 2007 Office System Driver: Data Connectivity Components to resolve the error. When I choose to export data to Excel and choose a file name of .xls, the export will error at 65,536 rows. If I choose to export data to Excel and select a file name of .xlsx, the export will complete without error. This is because in Excel 2010 there is a 1048576 row limit per sheet, and in Excel 97 there is a 65536 row limit per sheet.

2
  • That fixed my problem! Thank you! You are full of awesome and win!
    – Azzna
    Mar 29, 2016 at 14:07
  • :-) I like being told I'm full of awesome. You made my day.
    – stacylaray
    Mar 29, 2016 at 17:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.