Importing text files from an email

R

Rob A

Hi, As always I want to say thanks for all those respond and make this a
great community.

I recieve an email everyday with a text file, is there a simple automated
way to import the data into access.
It is a simple manual task, but automated is nice.

Manual process
Recieve email> right click text file>save as> open access and use the get
exteranl data> import functions.

Thanks Rob
 
P

Pete

Look at rules in outlook to push the attachment to a standard location.
Then use access, a button and/or macro/vba to check that directory location
and import what it finds. Error checking is important as email files and
txt stuff can arrive with strange conditons you'll want to catch. I usually
use an extra table I can check before it is commited to live tables.
 
Top