Importing Data Into Access From Email?

[johnwc]

Is it possible to automatically populate fields in Access with data
from a form that was submitted via an Internet interface to an e-mail
address? I understand that you would have to ensure that the field
names are the same in the e-mail form and in the Access database I am
importing into.

I was just wondering if it is possible to feed Access a batch of
e-mails with relevant data fields and have Access automatically store
the
information in the database as seperate records for each email? For
example, run a batch process that goes through each email in a folder
and extracts information from them
into Access as seperate records. That would save me some data entry
time at work.


Thanks!

 

[Tom Wickerath]

Hi John,

See if this thread provides information that is helpful for you:

http://groups.google.com/group/micr..._frm/thread/2c49153e6857e48d/477f5596a95dbf61


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[UpRider]

John, it is very possible that the data submitted to the form is stored in a
csv file on your web host computer. If so, use FTP to download it to your
local computer and import it into Access. It will just flow into an existing
or new table, ready to go. This is really painless and straightforward.

HTH, UpRider