Post reply

trc to xls

  • January 8, 2012 at 11:15 pm

    #254699

    i have a .trc trace file and i need to convert it in excel format, is there any tool

  • January 9, 2012 at 8:47 am

    #1430532

    no tool to convert to excel...we can convert .trc file into SQL Table..and may be you can copy the table to excel..

  • January 9, 2012 at 8:54 am

    #1430544

    Query the trace from SQL (fn_trace_gettable) then export as a .csv

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 9, 2012 at 11:49 am

    #1430716

    SELECT * FROM fn_trace_gettable('tracefilelocation.trc', default) Trace

  • September 26, 2012 at 2:44 pm

    #1542619

    Late to the party, but I did come across a free utility during my own search for such a thing:

    http://sqlmgmt.com/sql/Trace-Converter

    Cmd line, and single file at a time (or table), but it works reasonably well. Wish it'd take a directory!

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

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