Importing only one field from Outlook to Access

[Guest]

I accidently ruined the data in one of my database fields by cutting the
field size in the database design window. This was a field that was part of
an Outlook folder that had been imported into Access. So I deleted the field
in my Access database.

What I want to know is how to import only that one field from Outlook (the
Business Phone Number) without importing the entire folder itself with all
the rest of the fields. Can I do this? Thank you.

 

[John Nurick]

The difficult bit may be to ensure that you import the phone numbers
from the correct records. Try this:

1) add a BusinessPhoneNumber field to your Access table (which I'll call
tblContacts).
2) import or link the entire Outlook folder as a new table (let's call
it tblTemp).
3) create an ordinary Select query that joins tblContacts and tblTemp on
one or more fields (to ensure that each record in tblContacts "lines up"
with its counterpart in tblTemp). For example, join them on FirstName,
MiddleInitial, LastName, and PostCode.
4) test this query until you're sure it's delivering the right results.
5) convert it to an Update query that updates the new field in
tblContacts with data from the corresopnding field in tblTemp
6) run the query, delete the temporary table, and compact your database.