trc to xls - SQL Server Forums

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 Administration

trc to xls

Author

Topic

pnpsql
Posting Yak Master

246 Posts

Posted - 2012-01-09 : 01:02:51

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

challenge everything

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-01-09 : 12:47:09

Import it into SQL Server using either SQL Profiler or fn_trace_gettable to read it like a table. Then you can use bcp/SSIS/export wizard to export the results to a csv file, which Excel can easily read. So this will be a two-step process.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

X002548
Not Just a Number

15586 Posts

Posted - 2012-01-09 : 14:41:51

WHY...would you want to do that?

You lose the ability to query the data in a sql server 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

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources