View Full Version : Importing a single BIZ in multiple states HELP needed
11-03-2006, 11:00 AM
can anyone help ... I have data that references multiple states in a single cell ( AZ KY CO CA ) associated with a single cell. MP2004 will associate this if it were multiple countries but not multiple states. Any ideas ?
11-03-2006, 11:34 AM
I'm not sure I understand.
Do you have Excel ? You could do a "Data | Text to Columns" and split by the space?
11-03-2006, 11:43 AM
I have multiple states in one field in one record for a single customer. When this excel is imported, MP2004 does not recognize the indiv states. If I has multiple countries in a single field, MP2004 would recognize and separate the indiv countries.
11-03-2006, 11:51 AM
So what would it do when you import them, place a pushpin in each of the countries ? i.e. exploding the record? That sounds not normal.
I think you need to do some work on your input data, make one record per state.
You cannot make MapPoint do what it does not do... you have to make work-arounds yourself.
Powered by vBulletin® Version 4.2.2 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by vBSEO