Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 4 of 4

Importing a single BIZ in multiple states HELP needed

This is a discussion on Importing a single BIZ in multiple states HELP needed within the MapPoint Desktop Discussion forums, part of the Map Forums category; can anyone help ... I have data that references multiple states in a single cell ( AZ KY CO CA ...

  1. #1
    kwcarlberg is offline Junior Member White Belt
    Join Date
    Oct 2006
    Posts
    3

    Importing a single BIZ in multiple states HELP needed

    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 ?

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Importing a single BIZ in multiple states HELP needed

    I'm not sure I understand.

    Do you have Excel ? You could do a "Data | Text to Columns" and split by the space?

    Eric

  3. #3
    kwcarlberg is offline Junior Member White Belt
    Join Date
    Oct 2006
    Posts
    3

    Re: Importing a single BIZ in multiple states HELP needed

    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.

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Importing a single BIZ in multiple states HELP needed

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Import data with Multiple states per record
    By kwcarlberg in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-14-2006, 08:58 PM
  2. Importing multiple maps into Excel
    By dadburne in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 10-19-2005, 01:07 PM
  3. c# ImportData method help needed
    By fletch in forum MapPoint Desktop Discussion
    Replies: 8
    Last Post: 03-09-2005, 10:15 AM
  4. Less Address Accuracy Needed(!)
    By NickS in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 11-28-2003, 04:39 AM
  5. Zooming in to Multiple States
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 07-16-2003, 01:03 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96