Importing data from webtracker to database

I have a webtracking script that sends me an email whenever my site is visited which includes a few different pieces of information (i.e. ip, referer, etc) And the data comes to me looking something like this (for example):

Remote Host: 12.345.678.910
FQDN: 12-345-678-910.client.something.com
Date: Sunday, July 6, 2003
Time: 12:49:12 MST
Referer: www.yahoo.com
User Agent: Mozilla/4.0
Request: /home.php



What I want to be able to do is get this into an Access Database and I know there is an easier way to do this than by manually entering the data! I can combine all the messages and save it as a text file, if that helps any, which I tried to do, but the only thing I could think to do was to convert it to a table, but the data runs vertically rather than horizontally so obviously it doesn't work! I'm sure I'm missing something very basic about converting data to tables or something.... but really, I'm just incredibly frustrated! Any suggestions would be greatly appreciated!!

Do you have access to the code of this webtracking script? What language was it written in? The easiest thing would be to simply modify the script to send you the data in a comma-delimited (CSV) format. Better yet, have the script append its data to a growing CSV file on the site, which you can download and import into Access at any time.

Also, do you have any experience with scripting languages like Perl or PHP? A problem like yours could be solved in literally less than 20 lines of code in either of these languages (or less than 10, if you are a wiz).

Well, the short answer to that question is, I am by no means a php or perl programmer, I'm able to crawl my way around it and while I 'think' I have access to the code, I still have a bunch of previous emails (upwards of a few thousand) that are already sent to my inbox.., but for instance...someone suggested that I 'parse' the information and even gave me the code for it, the problem is....what do I do now? Where do I put this code? AHHH? I'm going to post this as a new thread, just in case the parsing catches someone's eye......

Honestly, if you are having this much trouble, you are probably better off just hiring someone who can do this for you. I say this because to do the things you want to do, you need knowledge of several areas of system administration, file/text manipulation, etc... and it really all takes some good background knowledge.

You are posting very general questions, without showing any details of what you might have tried, or what error messages or other problems you had, so its impossible for someone to just give you a quick easy answer.

No one can help you without knowing exactly what you have, and what you want to do with it. Here are the answers needed just for starters:

1. what email program are you using?
2. can you post the source code that the other person gave you to extract data from the emails?
3. Why not get the code to the webtracker program and post it here
4. in your first post, you say "I can combine all the messages and save it as a text file, if that helps any". Yes, this helps. If you can turn all your emails into one file, and if each "record" is formed exactly thesame way, then it should be fairly simple to manipulate the data into a readable format for Access import.

The thing is, you have to be willing to do your homework.