Importing Address, city state & zip from Excel

J

JackR

I am trying to import accounts into BCM, mu spreadsheet has the following
columns and I map them to:
Dealer to Account Name
Address to business address
City to business city
State to business state
Zip to business zip code

The problem is after I do that, when I view my contacts, in BCM, were the
address should be it only shows the City, state and zipcode.

Any help with this would be appreciated
 
L

Luther

I am trying to import accounts into BCM, mu spreadsheet has the following
columns and I map them to:
Dealer to Account Name
Address to business address
City to business city
State to business state
Zip to business zip code

The problem is after I do that, when I view my contacts, in BCM, were the
address should be it only shows the City, state and zipcode.

Any help with this would be appreciated

Check the log file created during imports, it may have a clue to what
happen. The other thing that may go wrong is that the address field
contains two lines in its Excel cell, and that may throw BCM off.
 

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

Top