G
gamer2k4
The company I work for is planning to switch over to BCM after using
Janna Contact for about fifteen years. Janna has been unsupported and
unupdated for nearly a decade, so this is kind of an important data
migration. Also, we have over 60000 records, so re-entering the data
is almost completely out of the question.
Does anyone have experience with this sort of thing? Is there a simple
way to transfer all of the information, or is it a multiple step
process? I've started work with queries and VB scripts in MS Access
(Janna uses .mdb files for its databases) to consolidate everything
into two tables (accounts and contacts), but I've heard it's also
possible to import Janna data into Quicken, and then import that data
into BCM. I'm sure there are other ways as well.
Finally, I'm curious as to how various things are imported. How are
notes handled? Does BCM take into account contact/account
relationships, and if so, how? What steps are needed to do that?
Thanks in advance for any help.
Janna Contact for about fifteen years. Janna has been unsupported and
unupdated for nearly a decade, so this is kind of an important data
migration. Also, we have over 60000 records, so re-entering the data
is almost completely out of the question.
Does anyone have experience with this sort of thing? Is there a simple
way to transfer all of the information, or is it a multiple step
process? I've started work with queries and VB scripts in MS Access
(Janna uses .mdb files for its databases) to consolidate everything
into two tables (accounts and contacts), but I've heard it's also
possible to import Janna data into Quicken, and then import that data
into BCM. I'm sure there are other ways as well.
Finally, I'm curious as to how various things are imported. How are
notes handled? Does BCM take into account contact/account
relationships, and if so, how? What steps are needed to do that?
Thanks in advance for any help.