MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Import locations

This is a discussion on Import locations within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I have 300 locations to map in Canada. I tried to import an Excel file with the name, the address ...


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

Import locations Import locations

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 Thread Tools Display Modes
  #1 (permalink)  
Old 09-10-2002
Senior Member
Black Belt
  
Join Date: Jul 2002
Posts: 5,138
Import locations
I have 300 locations to map in Canada. I tried to import an Excel file with the name, the address (ex: 453 King Street), the city and the province. I can't get Mappoint to recognize my address, so everytime it map the locations by the city. Is there a way to make this work, if not I will have to add the location one by one with the find option.

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
  #2 (permalink)  
Old 09-10-2002
John Meyer's Avatar
Senior Member
Blue Belt
  
Join Date: Jul 2002
Posts: 479
Could you post a sample (a row or two) of your excel file?
__________________
John
http://www.support-pc.com

Order MapPoint 2006 Here
https://secure.mp2kmag.com/?refer=support-PC
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 09-10-2002
Senior Member
Black Belt
  
Join Date: Jul 2002
Posts: 5,138
Name____Address____________City___________Province ______Country
9891318__500 Papineau_______Montreal_______Quebec________Canada
9894213__180 Tremblay_______Boucherville____Quebec________Canad a

I found out that if I choose USA for the country the matching option is set to street address but if it's CANADA the matching option is city. So i guess that I dont live in the right country to do what I want to do.

If someone knows a way to bypass this problem let me know.


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 09-10-2002
John Meyer's Avatar
Senior Member
Blue Belt
  
Join Date: Jul 2002
Posts: 479
I changed the country to United States (Which, as you pointed out gives you the "Data Type" Address 1 Column)

Then I selected Data Type City for the Province Column, clicked Finish and it imported just fine.

Give it another try, should work!
__________________
John
http://www.support-pc.com

Order MapPoint 2006 Here
https://secure.mp2kmag.com/?refer=support-PC
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

« Canadian postal code updates | when will MapPoint 2003 be available »

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
finding locations SimonPearse MapPoint 2006/2009 Discussion 0 09-23-2004 08:56 AM
Problem with locations Anonymous MapPoint 2006/2009 Discussion 3 09-12-2004 09:34 AM
Incorrect locations? harris00 MapPoint 2006/2009 Discussion 1 05-25-2004 10:40 PM
duplicate locations in one city Anonymous MapPoint 2006/2009 Discussion 0 07-28-2003 10:05 AM
array of locations Bart Vervenne MapPoint 2006/2009 Discussion 3 04-14-2003 04:03 AM


All times are GMT -5. The time now is 06:37 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

Cheap flights to Rhodes
For cheap flights to Rhodes make Holiday Hypermarket your final destination. Holiday Hypermarket help you to have a fantastic affordable holiday.

Portugal Weather
Check out Portugal Weather - Travel Counsellors details information on Portugal including, weather, flights and accommodation.

Flights Canada
Our search results will show you a selection of airlines, travel agents and tour operators offering cheap flights to Canada. See for yourself who has the cheapest deals.

Holidays to Mauritius
Visit the paradise island in your holidays to Mauritius. Enjoy the friendliness of the locals, the warm of the sun and the beauty of the views!

Cheap Cyprus Holidays
Finding cheap Cyprus holidays can be difficult unless you know where to look and where to book. With ulookubook.com you can conduct a simple search to find the latest holiday deals to your particular destination.

Inclusive late deals
For inclusive late deals, check out your options at Travel.co.uk and have fun!

Holidays to Gran Canaria
The Canary Islands await! Book holidays to Gran Canaria online 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