import outlook > access

[tregoyd]

Hi

I'm trying to import the contents of 'contacts' in outlook 2000 sr 1
to a table in access

using the get external data imports some, but not all fields from my
contacts - among others, it does not import the 'categories' field,
which is what I want - how can i get that

regards
Mike

 

[Milly Staples [MVP - Outlook]]

Have you tried Exporting from Outlook?

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal account will be deleted
without reading.

After searching google.groups.com and finding no answer, (e-mail address removed)
asked:

| Hi
|
| I'm trying to import the contents of 'contacts' in outlook 2000 sr 1
| to a table in access
|
| using the get external data imports some, but not all fields from my
| contacts - among others, it does not import the 'categories' field,
| which is what I want - how can i get that
|
| regards
| Mike

 

[SA]

Mike:

Millie's suggestion to export to a text file might be your only effective
method. The problem with Categories, is that it's a one to many type of
related data, i.e internally in Outlook's storage format, the Categories are
stored as an array of categories for the particular contact. There's no way
to pull that in in a single row table that the Outlook link wizard supports.

The other method would be to use automation and access the Outlook model
using VBA, looping through the contacts and grabbing categories, but having
not done that myself with the Categories data I can't tell you what might be
involved.

 

[mike]

Looks like exporting from access is it then...

Mike:

Millie's suggestion to export to a text file might be your only effective
method. The problem with Categories, is that it's a one to many type of
related data, i.e internally in Outlook's storage format, the Categories are
stored as an array of categories for the particular contact. There's no way
to pull that in in a single row table that the Outlook link wizard supports.

The other method would be to use automation and access the Outlook model
using VBA, looping through the contacts and grabbing categories, but having
not done that myself with the Categories data I can't tell you what might be
involved.

--
Steve Arbaugh
MS Access MVP

"Milly Staples [MVP - Outlook]"

wrote in message news:[email protected]...

Have you tried Exporting from Outlook?

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal account will be deleted
without reading.

After searching google.groups.com and finding no answer, (e-mail address removed)
asked:

| Hi
|
| I'm trying to import the contents of 'contacts' in outlook 2000 sr 1
| to a table in access
|
| using the get external data imports some, but not all fields from my
| contacts - among others, it does not import the 'categories' field,
| which is what I want - how can i get that
|
| regards
| Mike