Connecting Tech Pros Worldwide Help | Site Map

Get data from Web Page to Addess database

  #1  
Old November 13th, 2005, 05:03 AM
Dave Griffiths
Guest
 
Posts: n/a
I have a requirement to get data that people fill in on a form on a
remote web page into an access 97 database. The data will consist of a
number of simple text fields plus a photo.

I don't run the web server but they will try and fit in with what I
need. My idea is that whenever a submit button is clicked on the web
page then an email is generated with the body of the email containing
the text (what format - csv, xml ??)and with the photo as an
attachment.

So my first question is: is that a good way to go, or should I be
thinking along different lines?

If the email route is good, my second question is - how do I get the
data and photo from an email into the database? We use Outlook at this
end, and I can dedicate a machine to do this task and nothing else.
But can I manipulate Outlook from Access?

I'm not asking for an entire solution, but just trying to find out if
the principle is OK, and get some general clues about how to do it.

TIA
Dave
Closed Thread