Importing Web Form Data Into Access?

J

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 you
are using.

I was just wondering if it is possible to feed Access a batch of
e-mails with relevant data and have Access automatically store the
information in the database? For example, run a batch process that
goes through each email in a folder and extracts information from them
into Access.

Thanks!
 
D

Dylan Moran

I seriously doubt it. I wouldn't know of any system that could scan a free
text non formatted document, such as an email, even if the fields name were
in it and then import into access.

However, you may be able to do some sort of find and replace on the document
(emails), and somehow convert the text so that it is compatible with a comma
separated values, which you may then import.

Just an idea.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top