I have a sql 2005 table with around 135000 rows which need to be exported to a Excel file (office 2007).
Excel has limitation of 65536 rows.
Please suggest if we can split data and then export in two files or two tabs etc.

Also, if someone can suggest - we can write query

SELECT TOP 65536* FROM tbl_Name

What to write for the remaining rows?

Thanks