Online Form -> Email -> Access database

[Zman]

I've recently added form functionality on my website, which runs with the
aid of a perl script and sends the results via an email message.

I'm currently able to import, or link, data from a specific mail folder
(Outlook 2002) to an MS Access database (Access 2002). However, my problem
is the message body, which contains the data I'm interested in, is all
placed in the one field.

I would like the data contained in the message body to be imported into
separate fields but I have not been able to figure out how this is done.

I can arrange the data within the email message body to conform to a
particular format if needed, even HTML, but I can't work out how to import
the data into separate fields.

Tried searching this forum but couldn't find the answers. Perhaps there is a
better way of processing online forms, one which I'm not aware of.

My web service does support mySQL and also has ODBC dirvers for Access but
this to me seems like an over kill approach particularly since I don't need
access to data from the website (active pages)

Can anyone help?

Thanks.

[pietlinden@hotmail.com]

Re: Online Form -> Email -> Access database

You would have to write something to parse the single field into
multiple fields. Have a look at Split in the VB help. That will break
the single field into an array of values, which you can then write to
separate fields.

[pietlinden@hotmail.com]

Re: Online Form -> Email -> Access database

Come to think of it, probably the best way of dealing with this is to
write a script that Perl that does the insert directly into the
database. Then you could just run the two scripts one after another.

I would use parsing only as a last resort. it's really slow and
labor-intensive.

[Zman]

Re: Online Form -> Email -> Access database

<pietlinden@hot mail.com> wrote in message
news:1121390857 .536340.54350@g 47g2000cwa.goog legroups.com...[color=blue]
> Come to think of it, probably the best way of dealing with this is to
> write a script that Perl that does the insert directly into the
> database. Then you could just run the two scripts one after another.
>
> I would use parsing only as a last resort. it's really slow and
> labor-intensive.
>[/color]

I'll look into now that I have some idea where to start.

Thanks.