Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 convert SQL trace Files into .CSV format

Author  Topic 

Raja.DB
Starting Member

1 Post

Posted - 2007-03-01 : 03:44:20
How to convert SQL trace files into excel files without doing any work on SQL Profiler / SQL server using any scripting code.
Consider that we only have SQL Trace files. What are the steps involved in converting into .CSV format using single "CLICK"

Thanks,
Rajaram.
Chennai- India.

X002548
Not Just a Number

15586 Posts

Posted - 2007-03-01 : 10:03:16
I'm not aware of any "single click" to do this.

I would have had the trace to a table in the first place.

But Ii guess you could load the trace file into a table



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

alexylee
Starting Member

14 Posts

Posted - 2011-07-07 : 13:30:18
Here is a tool - TraceConverter that converts SQL trace file (.trc) to Excel file (.xls).

[url]http://www.sqlmgmt.com/ProductDetail.aspx?Id=106[/url]
Go to Top of Page
   

- Advertisement -