MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




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 2006/2009 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 ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

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

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read

Notices

Notice: Now taking orders for MapPoint 2009!


Click here to register

Reply

 

LinkBack (1) Thread Tools Display Modes
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 01-26-2006
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 01-26-2006
MapForums Plus Member
Senior Member
Black Belt
  
Join Date: Nov 2004
Posts: 2,055
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 01-26-2006
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 01-27-2006
Junior Member
White Belt
  
Join Date: Jan 2006
Posts: 1
Send a message via Yahoo to bhbaird
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5 (permalink)  
Old 05-16-2006
Junior Member
White Belt
  
Join Date: May 2006
Posts: 2
Send a message via Yahoo to rajalingam
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

« SelectionChange event | Modifying the Label in MapPoint »

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/mapoint-2004-importing-excel-how-sort-please-hel-4736.html
Posted By For Type Date
גוגל This thread Refback 09-27-2007 08:38 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Importing Zip Codes from Excel to MapPoint Jennl881 MapPoint 2006/2009 Discussion 2 02-05-2006 05:03 AM
Export to Excel - Sort Sequence Anonymous MapPoint 2006/2009 Discussion 0 01-08-2004 06:02 AM
importing data from excel to mappoint Layne MapPoint 2006/2009 Discussion 0 05-09-2003 12:40 PM
importing excel file into mappoint misterb83 MapPoint 2006/2009 Discussion 2 04-14-2003 01:56 AM
When importing from MS Excel .csv files into MapPo.... Anonymous MapPoint 2006/2009 Discussion 1 08-08-2001 07:35 AM


All times are GMT -5. The time now is 04:06 AM.

Marketing Strategy - VSAT - Used Cars - Book a Hotel - Moving Services - Archive - Top

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Ski Chalet
Fancy a ski chalet? Relax in comfort and style between skiing sessions. Holiday Hypermarket makes it easy for you to specify what kind of accommodation you want.

City Break Europe
Take a City Break in Europe. Based on holidays booked this year, these are the most popular City Breaks for 2006

Cheap Flight Canada
Making a cheap flight to Canada can become a reality when you book online with dealchecker.co.uk. Our simple search allows you to see for yourself who is the cheapest.

Maldives Holidays
If you are looking for a serene, laid back break in the sunshine, Maldives holidays are the choice for you. Be enchanted by the Maldives!

Cheap Portugal Holidays
Want to know what the best time to book cheap Portugal holidays is? Well have a look on ulookubook.com for some useful information to save your cash. Golf, tennis and cycling are all very popular here.

Bargain family holidays
We can help you find family holidays at bargain prices when you check out the options at Travel.co.uk

Cheap Holidays in Fuerteventura
Save your money! Live like royalty! Visit the Canary Islands! Get info on cheap holidays in Fuerteventura, only at On The Beach.


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