Import .trc files to database table

I've got a trace running at all times and it saves my traces into a number of .trc files, but how can I import the information into a table so I can get some value out of it?

Well first of all there's an awesome utility here (with whom I'm not affiliated in the slightest) called ClearTrace.

But sometimes I need more verbose reporting on my SQL traces, so I like to dump them into a table (e.g. "trace_table") and sort with my own queries.

Say you're at a place where you have a directory of .trc files on your server in C:\MyTraceFiles\.  Here's how you get them into your own table for easy manipulation:

SELECT * into trace_table FROM ::fn_trace_gettable('C:\MyTraceFiles\Trace_SERVER1_20110901195901.trc', default); insert INTO trace_table SELECT * FROM ::fn_trace_gettable('C:\MyTraceFiles\Trace_MyServer_20110901200002.trc', default); insert INTO trace_table SELECT * FROM ::fn_trace_gettable('C:\MyTraceFiles\Trace_MyServer_20110901200101.trc', default); ...