Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Location
    Swindon, UK
    Posts
    86

    Question Unanswered: Import Outlook Form Contents

    Hi,

    I have created an outlook form, all with named fields, now i need to import the data from these into an MS Access97 db table, also with the same named fields, does anyone know how to do this or have the code?

    Many thanks
    "Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done."

  2. #2
    Join Date
    Aug 2002
    Location
    Melbourne, Australia
    Posts
    111
    Open you Access db, go to Tables/ File/Get External Data/ Link Tables.

    When the dialog box opens Under "File of Type" select Outlook(). You will see a dialog box appear, choose what you wish and give it a try.

    Hope this helps.
    Regards,



    John A

  3. #3
    Join Date
    Feb 2004
    Location
    Swindon, UK
    Posts
    86
    Thanks for that, but unfortunately i don't have Outlook as an option in the 'File of Type'
    "Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done."

  4. #4
    Join Date
    Aug 2002
    Location
    Melbourne, Australia
    Posts
    111
    What version of Access and Outlook are you running?

    I am running office 2003.


    ....Sorry just re read your post and you are running access 97, so it looks like my suggestion was not correct.
    Regards,



    John A

  5. #5
    Join Date
    Feb 2004
    Location
    Swindon, UK
    Posts
    86
    yeah it's bit of a mess here, we are running Access 97 with Outlook 02
    "Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done."

  6. #6
    Join Date
    Feb 2004
    Location
    Swindon, UK
    Posts
    86
    yeah it's bit of a mess here, we are running Access 97 with Outlook 02

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ....it's bit of a mess here....
    What Swindon, or just your place of work?
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •