Post reply

sql problem

  • September 3, 2009 at 3:13 am

    #133349

    hello everone

    i have a new problem.

    Is this possible to send the data from a sql table to excel and do the calculation on the data there and after getting the answer again get the data in sql table.

    thanks in advance

  • September 3, 2009 at 3:36 am

    #1048602

    dheerajbaghel (9/3/2009)

    hello everone

    i have a new problem.

    Is this possible to send the data from a sql table to excel and do the calculation on the data there and after getting the answer again get the data in sql table.

    thanks in advance

    You can do this using either BCP or SSIS, for importing or exporting data. I would suggest that you look at BOL (books online).

    some of these links might help. I am sure that there are better articles on this site as well.

    http://www.mssqltips.com/tip.asp?tip=1202

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

    or you can run a query and in the results window, just right click with mouse and select all, then copy, and then paste into your excel worksheet.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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