Is it possible to import data from a e-mail?

[Niklas Östergren]

Hi!

I´m about to recive some data, regularly, from a website that we have. And
the guy who have made this website are not sure that he can deliver the
member apply data from our website in a delimeter textfile as an attachemnet
in a e-mail automaticly created as soon as the form at the web site hit´s
command button "Send".

So if that isn´t possible then I have to find out if it´s possible to
import data into an existing table in my application (A2003) directly from
an e-mail (from the bodytext). Is it possible?

If so is there some place I can read about how to do?

TIA!
// Niklas

 

[Mike Painter]

Hi!

I´m about to recive some data, regularly, from a website that we
have. And the guy who have made this website are not sure that he can
deliver the member apply data from our website in a delimeter
textfile as an attachemnet in a e-mail automaticly created as soon as
the form at the web site hit´s command button "Send".

So if that isn´t possible then I have to find out if it´s possible to
import data into an existing table in my application (A2003) directly
from an e-mail (from the bodytext). Is it possible?

If so is there some place I can read about how to do?

It is easy to link directly to Outlook from Access. File/Get External Data/
Link and pick Outlook as the type.

Make sure the information you get is delimited in some way.
Each column on a separate line or with a label

NAME: a name goes here ADDRESS: etc

After that it is just busy work to import the information.

If your web designer can't supply a delimited text file he or she is not
very competent.