Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Moving Contacts from Access 2007 to Oulook 2007

Jul 18, 2010 6:26AM PDT

Hello,

For my company I've created over 2000 contacts in an Access 2007 file, and I have about 700 in my Outlook 2007 contacts tab. I'm sure that some are the same in both, but I want to move all of my contacts from Access to Outlook. I've googled it and found some codes but I can't get an to work, as I don't really know how to use them. Is there any way to transfer them all from Access to Outook? I cannot save it in an earlier format either "because it uses features that require the current file format." Whatever that means.

Discussion is locked

- Collapse -
Re: contacts from Access to Outlook
Jul 18, 2010 5:53PM PDT

I see 2 options for you, in principle.

1. Find out how Export and Import of the Address Book in Outlook work. Once you know, export your data from Access in exactly the same format Outlook uses and import that file. If it's .csv (as it used to be in older versions) that might be easy.
2. Find out the 'methods' (that's OO language) to maintain the contacts in Outlook and write a program in Access that calls them with the right data.

The third option, of course, is to give up the idea to do it automatically and start typing.

Kees

- Collapse -
Re: contacts from Access to Outlook
Jul 25, 2010 5:46AM PDT

So do you mean to export the access data into a .csv file if outlook exports its contact data in .csv format then it could just automatically add it in the contacts?

- Collapse -
Re: export and import
Aug 7, 2010 12:26AM PDT

Sorry for the late answer. I was enjoying holiday and didn't look at these forums.

That's indeed what I meant: emulate the export from Outlook so you can use it in an import.

Kees