December 19, 2012 at 12:50 am
Hi,
I have one million records in sql server global temp table.i want to dump into excel sheet.
please suggest me of best way.
Thanks in advance...
Cheer's
Rajesh
December 19, 2012 at 2:55 am
Hi,
You must use office 2007 or higher version for a million records. Max rows an excel sheet can accept is 1,048,576.
SSIS is very flexible for such tasks like yours. I think this blog will help you
http://cavemansblog.wordpress.com/2009/04/17/ssis-export-data-from-sql-server-2005-to-excel/
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com
December 19, 2012 at 3:45 am
Thank's IgorMi.
if data will be more than 1.5 millions,then what is solution for this?because i have 1.6 millions of records.
Please suggest me....
Cheer's
Rajesh
December 19, 2012 at 3:53 am
Do you have to export to excel? Can you not export to another format, CSV, txt etc?
If it has to be xlsx then you will need to export 1 million rows into 1 sheet, then export the next 1 million rows to another sheet etc etc until all rows are exported.
What is the reasoning behind what you are trying to do? What is the expected outcome? Maybe there is a better way to do what you are trying to do.
December 19, 2012 at 5:01 am
rajeshpalo2003 78748 (12/19/2012)
Thank's IgorMi.if data will be more than 1.5 millions,then what is solution for this?because i have 1.6 millions of records.
Please suggest me....
Hi,
You can use for example two OLE DB sources with Data access mode: sql command. You can make two selects: one selecting the first million rows and the other selecting the rest 0.6 million rows.
Export both sets into two different excel documents or sheets.
There are more ways to do your task.
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply