Results 1 to 3 of 3
  1. #1
    salisbut is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    52

    Automated import


    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?

  2. #2
    dsmacs is offline Advanced Beginner
    Windows XP Access 2010 (version 14.0)
    Join Date
    Oct 2009
    Location
    Perth Western Australia
    Posts
    52
    Attached sample DB will give you some guidence;-

    Cheers
    Darren

  3. #3
    salisbut is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    52
    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".

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Automated Email Reports - monthly no clicks
    By Bamber in forum Reports
    Replies: 1
    Last Post: 05-12-2010, 12:34 PM
  2. creating automated ticket number
    By speak2des in forum Access
    Replies: 1
    Last Post: 02-25-2010, 11:32 AM
  3. automated macros?
    By tom4038 in forum Programming
    Replies: 1
    Last Post: 09-24-2009, 02:57 AM
  4. Automated Letter Composition
    By jmwheatley in forum Programming
    Replies: 7
    Last Post: 09-20-2009, 05:20 PM
  5. Automated many Rpts from one??
    By techexpressinc in forum Reports
    Replies: 0
    Last Post: 07-21-2009, 08:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums