Thread: SQL to Excel with more than 65536 rows

Hi

Doing a standard SQL export to excel from SQL Management. the Customer.dbo has approx 90,000 rows. Tried to export in both Excel 2003 and 2007 but always hits the dreaded 65536 max rows error.

Anyone got a way around this?

Unless you are going call 60,000 rows at a time and paste them into excel, you could use two sheets in one workbook to keep them together or maybe even just a workbook each (two files at the end of it.)

Alternatively you would have to get office 2010 which has extended limits.

http://office.microsoft.com/en-us/ex...in=HP005199291

Excel 2010 can handle up to 1,048,576 rows by 16,384 columns.

However it sounds like this number is only going to keep getting bigger. I suggest breaking up your SQL statements. Depending on what data you need would CSV file be enough?

Any idea if this will work with Excel 2011 (Mac)? Happy to download a copy to a boot camped Windows 7 but just want to keep this simple.

You are in luck!

http://www.nadynerichmond.com/blog/2...-2011-support/

Mac's match Windows spec in regards to Office.

Hope that helps!