MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




When importing from MS Excel .csv files into MapPo....

This is a discussion on When importing from MS Excel .csv files into MapPo.... within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; When importing from MS Excel .csv files into MapPoint 2002 to create pushpins, I always seem to get skipped records. ...


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

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 08-08-2001
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
When importing from MS Excel .csv files into MapPoint 2002 to create pushpins, I always seem to get skipped records. I have been through all the postcodes and I definitely know all the postcodes on the .csv files are correct. Why won't some of the locations show up? Is there anyway to update MapPoint's postcode database so every postcode will show up? If not, how can i place pushpins manually?

Thanks

James Lister
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 08-08-2001
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
This is a very common issue. Postcodes in some countries change at a rate of 10% per year, so even though the postcodes in your database may have been 100% correct when they were entered, they are unlikely to be 100% correct now. The same is true for the postcode data in MapPoint - it is a snapshot which may have been close to 100% correct at one time, but it is no longer 100% correct and going more out of date each day.



Unfortunately, there is no method for updating the internal MapPoint postcode data. There are some workarounds - like geocoding on street address instead of postcode (assuming you have full addresses), or getting your data geocoded in another program and then mapping your records in MapPoint using the lat/long value resulting from this geocoding work.
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


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
importing files Anonymous MapPoint 2006/2009 Discussion 1 04-14-2005 04:46 PM
Importing ESRI Shape Files (.shp) joer1234 MapPoint 2006/2009 Discussion 1 01-06-2005 06:35 PM
Importing mif files into MapPoint Anonymous MapPoint 2006/2009 Discussion 4 10-23-2003 04:23 PM
Importing E00 files bigRahn MapPoint 2006/2009 Discussion 1 03-24-2003 03:53 PM
i have a file in excel that is over 2000 and mappo.... Anonymous MapPoint 2006/2009 Discussion 1 11-14-2001 08:55 AM


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

Flight Deals
Book a holiday bargain online. Check out the latest fantastic flight deals. Holiday Hypermarket works with the leading Tour Operators to find the best flight deals available.

Turkey Weather
Check Turkey Weather before you travel. We provide information on Turkey including weather, flights and accommodation.

Cheap Holiday Turkey
Booking a cheap holiday to Turkey doesn't have to be at the expense of enjoyment. Dealchecker.co.uk searches holidays from the leading UK Tour Operators.

Holidays to Barbados
Holidays to Barbados have so much to offer. Enjoy the beauty of this Caribbean island for less by booking your holiday through us.

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.

Price comparison sites
Travel.co.uk is the one you are looking for when checking out price comparison sites.

Cheap Portugal Holidays
Hotels of all ratings! Find information on cheap Portugal holidays 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