SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Guru rashidr's Avatar
    Join Date
    Jun 2004
    Posts
    643
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Looking for Query Tool to Excel

    I am looking for query tool which exports ms sqlserver data to excel. Already searched google but not satisfied with the result. Is there any free tool available. which execute sql query and display output in excel

  2. #2
    SitePoint Zealot
    Join Date
    May 2005
    Location
    Suwanee GA
    Posts
    118
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by rashidr View Post
    Is there any free tool available. which execute sql query and display output in excel
    You can do it with PHP (search php output to excel) and if you have access to coldfusion it can do it too.

    Both use a variation of the header/content tags to point output to excel.


    header("Content-Disposition: attachment; filename=\"$filename\""); header("Content-Type: application/vnd.ms-excel");


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •