I am curious to know if I can run sql on the back end of a access database and grab an excel attachment from a daily email I receive and put it into a linked table into my database. Is this possible?
I am curious to know if I can run sql on the back end of a access database and grab an excel attachment from a daily email I receive and put it into a linked table into my database. Is this possible?
Attached sample DB will give you some guidence;-
Cheers
Darren
Ok this is exactly what I need. I tried running it, however, and is stalled at Ln 416 of the cmdProcess and said that "method or data number not found" which is in the section where it saves the file with a new name. Curious to know what might be the problem. I am running XP so it says in the intro it should work. I have checked the box "Add Date to Filename in the sender form".