Importing text files from an email

  • Thread starter Thread starter Rob A
  • Start date Start date
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
 
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.
 

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

Similar Threads

Importing Text Files Into Access 1
Importing Excel file without server access 3
Import files into access 1
Import from Notepad delimited text 7
Importing Emails from an Exchange Email box 1
import specific data 1
Import a Text File 2
Module To Import Text File Into Access Table 17

Back
Top