I am getting data sent to me in an Excel file that is attached to an e-mail. Is there any way of having Access import this data automatically into an existing table? I would like to automate this task since I get new data several times a day.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing data from an attached Excel file
- Thread starter rochelle
- Start date
jimmythegeek
Programmer
Look for help on the TransferSpreadsheet Method. You can set this up on a button to import files automatically. However, you need to name the file the same thing, and consistently put it in the same place. <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href= Application Development
- Thread starter
- #3
Thanks. That will handle importing the file once it has been saved to a separate file location. But is there any way of getting to it while it's still attached to an e-mail? I don't think it exists as a separate file until the e-mail has been opened. At that point I know I can see the file in my temp directory. Can I get to the attachment by somehow linking to the mail message from Access?
- Status
Similar threads
- Locked
- Question
- Locked
- Question