Software

Ask something
Discussion Locked

Exporting Outlook Contacts into Access

0 helpful
5 replies

by trechols

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When exporting Outlook contacts into Access, the 2nd line in the address field is not retained even thought I specify the "Map Custom Fields". All other data is exported fine. Can't find information in my Sybex book, or on MS technet.

5 replies

by oz_media

Is it the Export or the Importing?
I assume that you Export to a csv then Import the csv to your custom map. Is it creating the export fields OK and Access is not importing them?
If so, create a new map and use Address 3 in your Access base to import Address 2 from the csv. If it is an Outlook problem with it not exporting to the csv correctly, post back.

by oz_media

If you aretrying to IMport directly from Outlook, try creating a csv export for an Access import.
Outlook fields are sometimes funny when imported directly.

by trechols

Problem solved: Exported from Outlook to either an xls or csv file. You then select the address column in Excel and "format cells" and check "wrap text" - it treats the address as "one cell" instead of multiple. Importing the Excel information into Access worked. When "mapping fields" in Access I chose "Name" instead of "Title", "First Name", "Last Name", etc and it inserted all the information into one field. Thanks for the tips.

This discussion is closed to new replies.