Have you ever experience with excel limitation that only allow you to store up to certain row of data ?

 

If not, then I just want to share with you that Excel limit only 65,536 rows per worksheet. If you have more than 65,536 records, then you no choice, need to put it in another worksheet and this will be troublesome.

The easiest way to get rid of this limitation is to put your data in csv file.There are no limitation on how many records you want to put into it.

Using SQL Query Analyzer, you can export your result set to textfile but not to csv file.

Using Toad you can export your result set to csv format easily.

Toad is a powerful, low-overhead tool that makes database and application development faster and easier and simplifies day-to-day administration tasks.

Good news is that, there are few version of Toad. Currently there are Toad for Oracle,SQL Server,DB2 and MySQL

 

Below is capture screen to give you the idea how it works. See, it’s easy right.

Oh..not only csv, there are few other format that you can choose.

 

Hope it helps.