exporting SQL DATA TO EXCEL

[mathews1]

I want to export sql data output to excel but resultant lines are more than 1.5 millions but excel sheet can handle upto 65000 lines in one sheer. Is there any way that I can transfer upto 65000 lines in one sheet and 65001 and onwards move to next sheet and so on

please help?

-g

 

[vongrunt]

And then you'll need dual-code water-cooled machine to open that Excel file (translation: better don't ).

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[mathews1]

What is other way to handle this. Can I transfer to access

-g

 

[vongrunt]

Question is: what is the purpose of exported data? Backup, data transfer, reporting or something else?

Yes, data can be easily transferred/exported to Access DB.


------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[mathews1]

our auditor wants entire GL database into excel sheet for audit purpose