-
DTS Excel data exceeds 65536 rows
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|