Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

Exporting my Outlook contacts into an Access database

Hi there,

Does anyone know if there is a way of exporting Outlook contacts (Outlook 2003) into an Access 2003 database?

I have hundreds of contacts in my Outlook and have a database set up with the usual Title/First Name/Address1/Address2/ fields etc...

How could I export my contacts from outlook and then easily get them into the database?

Many thanks!
1 Solution

I would do this by exporting contacts from outlook into a .csv file, then using that .csv file to import into access.

If you need help going through this pls give me a shout!!


David LeeCommented:
Hi gjirvine3000,

Yes, it's definitely possible.  The absolute easiest way to do this is to use the Export feature built into Outlook (File -> Import & Export).  There's also a feature (File->External Data->Import) built into Access 2002/2003 (not sure about earlier versions) that'll read Outlook directly.  However, it suffers from a shortcoming of only handling certain contact fields.  If neither of these are suitable solutions, then it's easy enough to write some code in either Outlook or Access that'll read your contacts and copy them into an Access database.  

Both the answers above will work fine, I prefer to use the Access feature of File - Get External data - Import  and then choose the data type to be Exchange().  I have found this to be the quickest way to import from outlook to access

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now