Post reply

How can i export data in execel file in predefined excel format...

  • January 4, 2008 at 3:08 am

    #76860

    How can i export data in execel file in predefined excel format...

    Example suppose one excel file like..

    Report of newmwmber os year 2000 are following --- this is fix as header (for every ouput)

    field name ----these are fields name

    data -- -these are data

    .

    .

    .

    .

    .

    so, hearder is not in sql data...

    i want this solution...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • January 4, 2008 at 9:37 pm

    #765041

    3 pages starting at...

    http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 6, 2008 at 8:53 pm

    #765206

    You can also use sp_makewebtask

    exec sp_makewebtask @outputfile = 'C:\mypath\lester.xls',

    @query = 'select * from table',

    @colheaders =1,

    @FixedFont=0,

    @resultstitle= 'My Title',--Name of the report etc

    @dbname = 'db_name' --'database_name'

    Although i think this will be disregarded in MSSQL 2008 but anyways if your not using 08 as of now you can use this. Just my 2 cents..

    "-=Still Learning=-"

    Lester Policarpio

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

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