Exporting from MS Business Contact Manager into Access

[Ron]

I am new to developing a data base for my company using
Access. I have begun to use MS Business Contact Manager.
Can I import that data into an Access form without to
much work or problems?? In short, I want to develop one
system, and not have two for business contacts. If I can
not do this easily, I see the only option may be is to
not use MS Business Contact Manager at all...

 

[John Nurick]

Hi Ron,

I haven't used BCM myself yet, but as far as I can make out it is just
an Outlook add-in with no multi-user features, so is not much use as a
company contact manager if there is more than one computer in the
company.

Depending on the structure you use in the Access database it may or may
not be practical to export the contacts from BCM to your database. For
instance, your database may neeed to keep track of your firm's dealings
with organisations as well as with individual people representing those
organisations (who may be in different locations or departments). If so,
an Outlook contact record will typically correspond to two or more
records in the Access database, one for the person and one for the
company. Unless there are a very large number of existing Outlook
contacts, it's usually (IME) simpler to re-enter the data into the new
structure than to write and test the code needed to parse it and create
the new records under program control.

But it all depends on what purposes the company database is (and will
be) required to serve.