MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




The order in which data is exported to excel

This is a discussion on The order in which data is exported to excel within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Say that I have three pushpins in my map. If I select these, right-click and export to excel, - in ...


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

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



Click here to register

Reply

 

LinkBack (3) Thread Tools Display Modes
  3 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 03-25-2008
Junior Member
White Belt
 
Join Date: Feb 2008
Posts: 9
The order in which data is exported to excel

Say that I have three pushpins in my map. If I select these, right-click and export to excel, - in which order will they appear in the worksheet? It seems rather random to me...
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 03-25-2008
Senior Member
Blue Belt
 
Join Date: Dec 2002
Posts: 248
Re: The order in which data is exported to excel

lovetann,

You're correct. It definately requires programming to obtain ordering.

Mike Mattys
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 03-25-2008
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,480
Blog Entries: 1
Re: The order in which data is exported to excel

Luckily, Excel has some options to sort data.

Eric
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
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 03-26-2008
Winwaed's Avatar
Mapping-Tools.com
Red Belt
 
Join Date: Feb 2004
Posts: 899
Blog Entries: 10
Re: The order in which data is exported to excel

The question is: What order should the data be in? MapPoint doesn't know. As Eric says: Use Excel to sort on which ever data field you want.


If you used the pushpins to create waypoints, then we have a product which will sort them in route order: RouteWriter, see:

http://www.routewriter.com


Richard
__________________
Winwaed Software Technology LLC
http://www.winwaed.com
See http://www.mapping-tools.com for MapPoint Tools
Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009
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

Tags
data, excel, exported, order


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/order-data-exported-excel-7354.html

Posted By For Type Date
The Magazine for MapPoint - MP2K Magazine This thread Refback 03-27-2008 09:42 AM
The order in which data is exported to excel - MapPoint Forums This thread Refback 03-27-2008 12:08 AM
The order in which data is exported to excel - MapPoint Forums This thread Refback 03-26-2008 11:38 AM

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

 
Thread Tools
Display Modes

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
Import stops in route order using excel bpow MapPoint 2006/2009 Discussion 2 07-13-2007 02:16 PM
Map in same order as Excel input file gborge MapPoint 2006/2009 Discussion 3 10-06-2006 01:45 PM
strange order in the exported Excel flile pileggi MapPoint 2006/2009 Discussion 0 07-29-2005 11:08 AM
Export in Optimized Order to Excel erkorb Wish List 1 12-06-2003 01:24 PM
Have successfully exported a map selection from Ma.... Anonymous MapPoint 2006/2009 Discussion 1 09-05-2001 05:14 AM


All times are GMT -5. The time now is 08:20 PM.


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


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