Post reply

How to export sqlserver 2005 database table to excel sheet

  • February 19, 2009 at 3:37 am

    #73507

    Hi, Good day

    How to export sqlserver 2005 database table to excel sheet

    Eg:-My Database name is PRINCE (Sql server 2005), it having tabled called EMP

    Its having 20000 records approximately, how export this EMP table data into excel sheet

    Thanks & Regards

    rclgoriparthi

  • February 19, 2009 at 6:13 am

    #946590

    Dear friend,

    you can use excel's feature of import data from data section.

    there u can write selecte satement s and can retrive the data.

    Mithun

  • February 20, 2009 at 3:37 am

    #947395

    For a once only export use SQL Server Import and Export Wizard:

    Right Click on the Database then:

    Tasks->

    Export Data->

    Next->

    Data Source = PRINCE ->

    Next->

    Destination = Microsoft Excel; Excel File Path = Browse "Your File Name Here"

    Next->

    Next->

    Source = EMP->

    Next->

    Next->

    Finish

  • February 20, 2009 at 10:47 am

    #947700

    Why did you post a question related to SS2K5 in this SS2000 forum ?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply