PDA

View Full Version : Importing a single BIZ in multiple states HELP needed



kwcarlberg
11-03-2006, 10: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 ?

Eric Frost
11-03-2006, 10: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?

Eric

kwcarlberg
11-03-2006, 10: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.

Eric Frost
11-03-2006, 10: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.

Eric