Linked Outlook table does not bring over Categories...

[jimmy fallon]

I know this may be the wrong forum, but nobody is answering me in the other
one. This seems to me to be a simple issue, but I can't find and answer.
When I link to an Outlook contact folder using the "external data" tab and
then clicking on "more" then outlook, it brings over every field accept for
the categories field. How am I supposed to separate my business contacts from
my personal ones? I can't create a separate Outlook folder because, I need to
sync all with my phone, and the phone only syncs to the contacts folder. Not
looking for a work around, looking for the way to bring Categories field over.
Thanks if you can...
jf

 

[JulieS]

I know this may be the wrong forum, but nobody is answering me in
the other
one. This seems to me to be a simple issue, but I can't find and
answer.
When I link to an Outlook contact folder using the "external data"
tab and
then clicking on "more" then outlook, it brings over every field
accept for
the categories field. How am I supposed to separate my business
contacts from
my personal ones? I can't create a separate Outlook folder
because, I need to
sync all with my phone, and the phone only syncs to the contacts
folder. Not
looking for a work around, looking for the way to bring Categories
field over.
Thanks if you can...
jf

Hello Jimmy,

The standard map called from Access 2007 does not include the
category field. However, you can easily export information from
Outlook 2007 as an Access table. That map automatically includes
the category field. From Outlook choose File > Import and Export,
Export to a file to get you started.

I hope this helps.

Julie

 

[jimmy fallon]

When I do that, Category field comes over BLANK.
jf

 

[JulieS]

Have you assigned categories to your contacts? When you look at your
contacts in the "By category" view -- do you see them separated by
category?

Julie

 

[jimmy fallon]

yes, I rely heavily on my categories, that's why it just blows my mind that
they do not some over into Access when linked. what's the point of a database
if you can't filter by a field?

jf

 

[JulieS]

Jimmy,

I'm not able to reproduce what you report. I have resources
assigned categories in Outlook 2007, when I export using the
standard export map in Outlook all categories export. When you
exported from Outlook did you confirm the categories field was in
the map and correctly mapped to the Access field?

Julie

 

[Rick Brandt]

yes, I rely heavily on my categories, that's why it just blows my mind
that they do not some over into Access when linked. what's the point of
a database if you can't filter by a field?

There's the rub. Outlook is not a database so it doesn't particularly
behave like one.