Software

Ask something
Question Locked

Outlook contacts as Access table

0 helpful
7 replies

by lord foul 2 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How can you link existing Outlook contacts to an Access database?

The database we are creating has a table named contacts. Instead of duplicating the contacts in Access, we would like to link the Outlook contacts to the Access database, contacts table.

Using Outlook/Access 2003.

Cheers

7 replies

by agorman1

I'm looking for the same thing. It seems like something that *should* be fairly easy to do and not terribly unusual...

by thawiz

Create a link to the Outlook Address book. Go to File, Get External Data, Link Tables. Change File of type to Outlook and expand Personal Folders to reveal the Contacts Folder. If you have additional Contacts folders expand the Contacts folder and select the one you want. When you hit Next it will ask what you want to name your linked table. This will create a table link and you can create a form to go along with it.

by instib

Y does it say that i dont have outlook installed on my computer?

by piergrossi

The problem is once the link is made, there is no key to link the records to other tables. The table cannot be modified to add a key either. Any suggestions?

by thawiz

Yes. Though it is preferable to use a unique identifier/key you may link to another table using any field. I would use a userdefined field to hold a key and maintain it in a separate table.

by bhernandezca

Can you provide an example of how to setup the Access table with the primary key for the Outlook contacts?

This discussion is closed to new replies.