MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Importing Data

This is a discussion on Importing Data within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I have an end user who is importing data from an excel spread sheet. For some reason the phone numbers ...


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 10-06-2003
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
Importing Data

I have an end user who is importing data from an excel spread sheet. For some reason the phone numbers are not displayed properly. It looks like they are being added or multiplied or in some cases commas are being inserted. Can you please help.
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 10-06-2003
Junior Member
Yellow Belt
 
Join Date: Feb 2003
Posts: 28
Importing Data

If your phone number is not formatted (ie 000-000-0000 or (111) 111-1111) Mappoint tries to use it as a number. If you are using the Data Wizard and try to add data using the phone number field (unformatted phone numbers) the wizard, by default, seems to sum numbers. Try formatting the cells containing the phone numbers to look like xxx-xxx-xxxx or something of the sort. This seems to fix the way the phone numbers are displayed.
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, importing


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
Help with Mappoint importing data with data ranges Anonymous MapPoint 2006/2009 Discussion 0 08-31-2003 11:28 AM
Importing data to Mappoint gsully MapPoint 2006/2009 Discussion 3 06-25-2003 03:50 AM
Importing Data Anonymous Wish List 0 10-05-2002 12:49 PM
Importing new GIS data and querying it. Anonymous MapPoint 2006/2009 Discussion 1 09-26-2002 09:29 AM
Is there any way of importing map data into MapPoi.... Anonymous MapPoint 2006/2009 Discussion 1 05-23-2002 04:08 AM


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