PHP to Outlook To Access

D

Dawn

I am a rookie trying to organize data that I receive from a PHP web form.
What is the procedure I would use to transfer the form results into an
Access database. I do not want to use this data on a web page.

The biggest problem is that the data arrives with the field data organized
by row not by column.
Thanks
 
M

Mike Painter

Dawn said:
I am a rookie trying to organize data that I receive from a PHP web
form. What is the procedure I would use to transfer the form results
into an Access database. I do not want to use this data on a web
page.
The biggest problem is that the data arrives with the field data
organized by row not by column.
Thanks
Click to expand...

If you have control over the PHP side you could send the data in a comma
delimited format.

If not you will need code to parse the message.
You can attach Outlook and get the messages directly into Access.
You need to use some delimiter and if the form comes across with something
like
NAME: somename goes here ^P
ADDRESS: some street ^P
CITY: Mycity^P (Where ^P is a CRLF)

then you search for NAME, get everything after name up to the CRLF gets put
it a variable, etc.
Then use Insert Into to add the record.

You can then delete the original record.

It's just busy work after you catch on to the idea.
 
T

Tony Toews

Dawn said:
I am a rookie trying to organize data that I receive from a PHP web form.
What is the procedure I would use to transfer the form results into an
Access database. I do not want to use this data on a web page.
Click to expand...

See the Inserting data from incoming emails into tables tips page at
http://www.granite.ab.ca/access/emailincoming.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
M

Mike Painter

Not off the top of my head but if you have the PhP code, just get rid of the
linefeeds <br> and replace Name, address, etc with a comma.
 
Top