Squid access.log to MS Access
I've been trying to import Squids access.log into an MS Access DB so I can run reports on username names. I have been importing the log into Excel where I can select use "Treat multiple delimiters as one". This way when my elasped time only had 1 or 2 digits instead of 3, it would import correctly.
Recently my logs are getting to big to import into Excel. I've tried going straight into Access but Access does not offer the "Treat multiple delimters as one" opition when importing. This throws off my colums badly.
Is there any way to restructure the Squid log file or some get Access to "Treat multiple delimiters as one"? I wouldn't even mind running the log through some sort of script or converter so it was tab or comma limited.
Any help?
Thanks,
MePH
|