INSERT TableName
SELECT Col 1,Col 2,......
FROM ::fn_trace_gettable( '\\ServerName\DirectoryPath\Filename', 0)

CREATE VIEW vw_LookitMyTrace
AS
 SELECT * FROM ::fn_trace_gettable('C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\log_10.trc', default)

    --we want the current trace folder
    declare @path nvarchar(256)
  --ie c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG  
  SELECT @path = REVERSE(SUBSTRING(REVERSE(path),CHARINDEX('\',REVERSE(path)),256)) FROM sys.traces WHERE is_default = 1
--you can select either the real default trace, or your specific trace.
  SET @path = @path + N'LookitMyTrace' --system appends .trc automatically for the filename
  IF EXISTS(select * from master.dbo.sysobjects where xtype='V' and name='LookitMyTrace ')  
  BEGIN  
    SET @sql = 'ALTER VIEW LookitMyTrace AS SELECT * FROM ::fn_trace_gettable(''' + @path +'.trc'', default)'  
    exec(@sql)  
  END  
ELSE  
  BEGIN  
    SET @sql = 'CREATE VIEW LookitMyTrace  AS SELECT * FROM ::fn_trace_gettable(''' + @path + '.trc'', default)'  
    exec(@sql)  
  END  
  COMMIT TRAN
END