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 5 of 5

Mapoint 2004 Importing from Excel - how to sort - please hel

This is a discussion on Mapoint 2004 Importing from Excel - how to sort - please hel within the MapPoint Desktop Discussion forums, part of the Map Forums category; When importing data from EXCEL it creates pushpins. When adding pushpins as stops, how do you ensure they are added ...

  1. #1
    Marktherob is offline Junior Member White Belt
    Join Date
    Nov 2005
    Posts
    3

    Mapoint 2004 Importing from Excel - how to sort - please hel

    When importing data from EXCEL it creates pushpins. When adding pushpins as stops, how do you ensure they are added in a specific order. I have drop numbers that we keep in our database and this data is exported to excel my data is sorted by drop, however this data gets set up in mapoint(add pushpins as stops) in its own way but it is consistent. Please help.

    Thanks Mark

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi,

    I dont know if mappoint.exe uses any sort criteria. A solution could be using the ocx in Excell itself if you know some VBA. Then you have control over all.

  3. #3
    Marktherob is offline Junior Member White Belt
    Join Date
    Nov 2005
    Posts
    3

    importing data from EXCEL

    the data is sorted in excel correctly. What I need is mappoint to keep it in that order.

    Thanks

  4. #4
    bhbaird is offline Junior Member White Belt
    Join Date
    Jan 2006
    Posts
    1

    Re: Mapoint 2004 Importing from Excel - how to sort - please

    Quote Originally Posted by Marktherob
    When importing data from EXCEL it creates pushpins. When adding pushpins as stops, how do you ensure they are added in a specific order. I have drop numbers that we keep in our database and this data is exported to excel my data is sorted by drop, however this data gets set up in mapoint(add pushpins as stops) in its own way but it is consistent. Please help.

    Thanks Mark
    In my opinion you need to switch over to MS Access for full conrol of routing and pin placement.

  5. #5
    rajalingam is offline Junior Member White Belt
    Join Date
    May 2006
    Posts
    2

    re:Mapoint 2004 Importing from Excel - how to sort -

    Mappoint adds pushpins on the map from left to right.

    you can add them as way points using a loop in th excel vba routine or in ACCESs. Also that way you can control the ouput format. There are some codes available in the forums.

    hope that helps.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Importing Zip Codes from Excel to MapPoint
    By Jennl881 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 02-05-2006, 06:03 AM
  2. Export to Excel - Sort Sequence
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 01-08-2004, 07:02 AM
  3. importing data from excel to mappoint
    By Layne in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-09-2003, 01:40 PM
  4. importing excel file into mappoint
    By misterb83 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 04-14-2003, 02:56 AM
  5. When importing from MS Excel .csv files into MapPo....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-08-2001, 08:35 AM

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