Import Data

G

Guest

Hi
Does anyone know how to import data from an Access-Database. In the
Access-Database I got three tables: Company, Contact-Person and Histories to
Contact-Persons (linked by IDs). This cannot be done with the import-wizard
in BCM, the linking between Companies and Contact-Persons are not supported.
Is it possible to fill the data directly to the bcm database?
 
G

Guest

Thanks for your reply

It seems to be impossible to import data from linked tables for expl. from
access. What will users do, who have thousands company- and
contact-addresses?

Chris
 
L

Luther

If your data is spread across several tables, you'll have to aggregate
the fields you want into a single view and then export that table to
CSV and import it into BCM.

There's no way any application can guess which fields scattered across
multiple tables in a database are important to you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Migrating from BCM to Dynamics. How to export phone logs, tasks 1
Migate frm Public contact folder to BCM supported by SQL 2
Existing/prior correspondence does not appear in contact history. 1
Importing Salesforce information to BCM 5
Can not import the US BCM 2003 database into Dutch BCM 2007 1
Connection to BCM database 1
import database 3
Importing Accounts and Contacts 3

Top