MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Exporting places inside a selection to Excel

This is a discussion on Exporting places inside a selection to Excel within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I want to make a radius circle selection of places that are found using the info tool and export those ...


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 Thread Tools Display Modes
  #1 (permalink)  
Old 06-06-2003
Junior Member
White Belt
 
Join Date: Jun 2003
Posts: 1
Exporting places inside a selection to Excel

I want to make a radius circle selection of places that are found using the info tool and export those to Excel. Is that possible? I don't seem to be able to do this. I would like to create a list of places like marinas, restaurants and such to visit on my vacation from the places that exist in MapPoint.
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 06-09-2003
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
Export places inside of selection to Excel - Same question

I have the same question. How do I export to Excel items which are listed from a "Find Nearby Places" within the radius. I have imported into MapPoint recent house sales and want to export only those within 2.5 miles of an address.
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 06-09-2003
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
I found the solution in the tutorial. You need to select area with a closed shape, such as a radius. (You cannot pull simply using the "Find nearby places" selection). Here is the section copied from Mappoint tutorial.

Export data to Microsoft Excel
Open the map from which you want to export data.
Do one of the following:
Draw a closed shape (such as a drivetime zone or freeform, rectangle, oval, or radius circle shape) around the data you want to export, and then select the shape by clicking its border.

On the Navigation toolbar, click Select , and then drag from the upper-left corner to the lower-right corner of the area that includes the data you want to export.

Select the data set name in the legend.

On the Data menu, click Export to Excel.
- or -

Click Export to Excel .

Microsoft Excel starts, and the entire data set or any data mapped entirely within the shape you drew is exported and presented in an Excel workbook (see the notes below for more information). The workbook includes a header sheet with the dimensions of the area you selected, the name of each data set that was included, and the total number of records exported from each set.

Each data set is included on a separate tab of the Excel workbook with the first tab as the header sheet.

Notes
You can only export data from one closed shape at a time; that is, any shapes on the map other than the selected closed shape will be ignored.

Selecting an area or shape at a high altitude could result in unreliable export data. It is possible that the two-dimensional shape will extend beyond the three-dimensional curvature of the Earth that is rendered on the map. To avoid this problem, try the following:

Select the shape, and on the View menu, point to Zoom, and then click To Selection.

Use the Select tool to zoom
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
excel, exporting, inside, places, selection


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
Exporting the "show or hide places" jhoffend MapPoint 2006/2009 Discussion 5 09-20-2007 01:43 PM
Exporting to Excel getgo MapPoint 2006/2009 Discussion 1 06-06-2006 03:07 PM
Exporting to Excel bakibbe MapPoint 2006/2009 Discussion 2 09-07-2005 08:15 AM
Exporting territory info to excel Anonymous MapPoint 2006/2009 Discussion 0 11-06-2002 06:16 PM
Exporting data to Excel Anonymous MapPoint 2006/2009 Discussion 0 08-28-2002 03:57 PM


All times are GMT -5. The time now is 05:38 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2009, 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 55