Convert Log file to database

[nmattheij]

I mainly use Webtrends for analysis, but I'm looking for a little program that will import my log files into a database table, so I can perform SQL searches on it.

Looking into raw logfiles doesn't get me very far most of the time, being able to run queries on it with sql could really help me figure out a lot of stuff without having to create and run complex Webtrends reports.

So basically all I need is a tool that will create a table/database with the log fields as columns and put the log data in it.

Preferably with me being able to filter on extensions and/or ips, and imports of multiple logfiles.

Any ideas?

[kichus]

This is a link from Microsoft site, So I think it's okay ti mention here...

"How To Use SQL Server to Analyze Web Logs"
[support.microsoft.com...]

[Iguana]

I just pull my logs into Microsoft access (using text import with space as the separator).

[cgrantski]

Also look at LogParser (on the Microsoft site). It was designed with logs (in general) in mind, and so might be even more appropriate than Access.