Is it possile to email xml files into a database

[Bill]

Is it possile to email xml files into a database. We have a pdf form that is
completed by staff then emailed from the form to an email address in xml
format. It takes a minimum of six keystrokes to enter the xml data into the
database. We are looking for an way to auto enter the xml data from the
email into the access 2007 database

 

[Sylvain Lafontaine]

There are many possibilities here. If these emails are coming into an
Outlook account (but not Outlook Express), you could monitor it in order to
automatically grab any incoming email. See an example at:

http://groups.google.com:80/group/comp.databases.ms-access/msg/f2b38e0abd1559d5

There are other possibilites like using the POP3 protocol to receive these
emails directly from the SMTP server or to look into the directories of the
SMTP server if the one that you are using give you this possibility. For
example, if you search Google for "pop3 receiving email", you'll stumble on
articles such as:

http://www.dimac.net/Products/W3jmail/Version43/Examples/POP3.htm

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)