Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jul 2002
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    exporting data to outlook (access 2000)

    What is the text string or csv format for access to export calendar appointment information so that outlook can import it? The help file says it can be done but doesn't explain the field settings (criteria).

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: exporting data to outlook (access 2000)

    To export data from Access to Outlook, the easiest way is to use the Import/Export Wizard in Outlook. It is capable of reading and writing Access tables directly - however it makes some assumptions about your table structure which you will need to validate. I would suggest you create a few contacts in Outlook and then export them to an Access database to see what kind of table structure results. Then tinker with the structure a bit to enhance it, and take the data back to Outlook. There are some fairly serious constraints in the way that Outlook handles contact information (email addresses and phone numbers for example), but it will meet lots of needs and has some nice integration features.

    If you want to get more adventureous, you could try manipulating Outlook data using Automation - with that you can create, edit and delete contact entries in Outlook. The Outlook object model does have some fairly serious constraints, but once you figure those out, you can actually do a fair bit with the combination of Access and Outlook.
    Wendell

Posting Permissions

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