« Ubuntu Hardy Heron FREE CD arrived
MS SQL - Find MAX value from varchar/nvarchar field. »

Export SQL result to CSV file easily.

 

Microsoft Excel (Windows)

Image via Wikipedia

 

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.

excel the end

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. :)

csv

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

output format

 

Hope it helps. :)

[Ask] [Bloglines] [del.icio.us] [Digg] [Furl] [StumbleUpon] [Technorati] More »

If you're new here, you may want to subscribe to my RSS feed or get my latest post directly in your mailbox. Thanks for visiting !

Related Post:
  • Wordpress 2.5 - Upgrade my blog to new folder.
  • The day when VLOOKUP saves her day.
  • Design your AutoIt application using Koda FormDesigner
  • How to create .htaccess file in windows
  • How to Install Omnet++ in Ubuntu 8.04



    • Can't find what you are looking for? Go Gooogle...
    Google

    4 Responses to “Export SQL result to CSV file easily.”

    1. OktaEndy on May 29th, 2008 at 10:30 pm Using Mozilla Firefox Mozilla Firefox 2.0.0.14 on Windows Windows XP

      Blom pernah pake toad sih..
      tapi sepertiinya tools yang “indah” hehehe
      thanks buat infonya, bisa menambah wawasan kalau2 butuh exporter.

    2. arejae on May 29th, 2008 at 11:13 pm Using Mozilla Firefox Mozilla Firefox 3.0b5 on Linux Linux

      hi andy,yeah..harap ianya membantu :) thanks for visiting yer.

    3. drizzter on June 1st, 2008 at 10:20 pm Using Mozilla Firefox Mozilla Firefox 2.0.0.14 on Windows Windows XP

      deeply technicalnyo blog demo arejae wes… hahaha .. ngakk bisa ambo nok implement ..

      bab english toksoh risau la tungging tanggok pom .. kawe 2×5 … wak lolok bijok jah

      buke betul pom grammar kawe hahaa

    4. arejae on June 2nd, 2008 at 6:57 am Using Mozilla Firefox Mozilla Firefox 3.0b5 on Linux Linux

      aloh lar abey,takdok lar teknikal sangat weh,byk lagi keno belajar. :)
      ho lar…english kawe ni bukey stakat tungging tanggok doh…nammo ghima tok tahu lar. ehehe…hantam saja.

      anyway, welcome to my blog and enjoy your stay. do correct me if im wrong yer. :)

    Leave a Reply

    AWSOM Powered