Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Unanswered: SQL Data from query to Excell file

    Hi
    I have a simple database in SQL Server 2005...
    I made a simple query like this....

    Select CitiesName,CitiesSize
    From Cities

    I save this query.......Now i want to run it from excell 2003 or 2007.... I mean the 2 columns that query brings(Cities_Name, Cities_Size) bring it in excell file....
    I know that i can input data in Excell from a Table... But can i input data from a query???????????? Because my table have many fields and i want only these 2....
    Is there any other way????

    Thanks in advance

  2. #2
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    assuming that u want to retrieve the data from the sql server database into an XL sheet, u can use SSIS to do this..
    Cheers....

    baburajv

  3. #3
    Join Date
    Dec 2008
    Posts
    135
    if u want the result of a query in a file (excel)
    before executing the query
    click ctrl+shift+F then u can save the output in any file (.extension)

Posting Permissions

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