MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Automatic update in mappoint from excel changes

This is a discussion on Automatic update in mappoint from excel changes within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hello, I am trying to create a map that has an imported excel spreadsheet that will be updated when I ...


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 (1) Thread Tools Display Modes
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 07-18-2008
Junior Member
White Belt
 
Join Date: Jul 2008
Posts: 2
Automatic update in mappoint from excel changes

Hello,
I am trying to create a map that has an imported excel spreadsheet that will be updated when I make changes in the spreadsheet.

My instruction booklet says I can go to Data Mapping Wizzard and Link To Data "to map it to link data from an external source, retaining the link, and allowing future changes."

However, when I make changes in that excel spreadsheet, there are no changes on the map.

Any suggestions?

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 07-18-2008
Senior Member
Blue Belt
 
Join Date: Dec 2002
Posts: 248
Re: Automatic update in mappoint from excel changes

Data Menu ... Update Linked Records
Shift+F9
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 07-18-2008
Junior Member
White Belt
 
Join Date: Jul 2008
Posts: 2
Re: Automatic update in mappoint from excel changes

Right, thanks.

I tried that and it said "One or more data sets could not be successfully updated." Do you know why this might be?

Thank you
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 07-18-2008
Senior Member
Blue Belt
 
Join Date: Dec 2002
Posts: 248
Re: Automatic update in mappoint from excel changes

Empty row, possibly.
Maybe even a column that was removed.

Sometimes the solution is to delete and relink

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
Reply

Tags
automatic, excel, mappoint, update


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/automatic-update-mappoint-excel-changes-8073.html

Posted By For Type Date
Spatial Data Importer Contest Submission - MP2K Magazine This thread Refback 07-21-2008 01:13 PM

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
Update MP 2004->2006 // Now Problems with VBA-Excel-Makros... 50miles/100miles... Maik1976 Development 0 06-19-2008 08:52 AM
Virtual Earth Update: New Live Search Maps Update VE For Government Virtual Earth Blogs 0 10-17-2007 10:41 AM
Automatic Downloads/Uploads BC1968 MapPoint 2006/2009 Discussion 4 08-30-2007 01:00 PM
Link Data to Excel update MP resets or can't place address GEB MapPoint 2006/2009 Discussion 3 10-01-2005 05:30 AM
Automatic Zip Code tak_ibi MapPoint 2006/2009 Discussion 0 08-11-2003 05:29 PM


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