Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2007
    Posts
    197

    Smile Unanswered: export data in excel or .csv file

    hi all

    I tried in enterprise manager to export data in .csv file or excel sheet
    but cant get can any help me to export data
    Attached Thumbnails Attached Thumbnails CSVfile.JPG  

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    The whole database?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Jun 2007
    Posts
    197

    Smile

    hi

    I got the software to export import file

    http://www.teratrax.com/tdm/

  5. #5
    Join Date
    Jun 2007
    Posts
    197

    Smile

    I there any function in MS SQL SERVER 2005 click and export import data in csv format

  6. #6
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    to export - in query window set the tools>>option>>query results>.results to text>>out put format to "comma delimited". click on "results to file" and fire your sql.

    to import - u can use TSQL OPENROWSET function.

  7. #7
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    SSIS is another good tool to handle such tasks.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  8. #8
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    I prefer bcp for this.

  9. #9
    Join Date
    Jun 2007
    Posts
    197

    Smile

    Quote Originally Posted by upalsen
    to export - in query window set the tools>>option>>query results>.results to text>>out put format to "comma delimited". click on "results to file" and fire your sql.

    to import - u can use TSQL OPENROWSET function.

    I have done all the setting according to you

    suppose the table is ISMWL so what will be query to export data in csv format

  10. #10
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    I have done all the setting according to you
    suppose the table is ISMWL so what will be query to export data in csv format
    Oh! no... it is any Select SQL.... in simplest form "select * from ISMWL"....

Posting Permissions

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