MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Importing a single BIZ in multiple states HELP needed

This is a discussion on Importing a single BIZ in multiple states HELP needed within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; can anyone help ... I have data that references multiple states in a single cell ( AZ KY CO CA ...


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 11-03-2006
Junior Member
White Belt
 
Join Date: Oct 2006
Posts: 3
Importing a single BIZ in multiple states HELP needed

can anyone help ... I have data that references multiple states in a single cell ( AZ KY CO CA ) associated with a single cell. MP2004 will associate this if it were multiple countries but not multiple states. Any ideas ?
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 11-03-2006
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,487
Blog Entries: 1
Re: Importing a single BIZ in multiple states HELP needed

I'm not sure I understand.

Do you have Excel ? You could do a "Data | Text to Columns" and split by the space?

Eric
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 11-03-2006
Junior Member
White Belt
 
Join Date: Oct 2006
Posts: 3
Re: Importing a single BIZ in multiple states HELP needed

I have multiple states in one field in one record for a single customer. When this excel is imported, MP2004 does not recognize the indiv states. If I has multiple countries in a single field, MP2004 would recognize and separate the indiv countries.
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 11-03-2006
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,487
Blog Entries: 1
Re: Importing a single BIZ in multiple states HELP needed

So what would it do when you import them, place a pushpin in each of the countries ? i.e. exploding the record? That sounds not normal.

I think you need to do some work on your input data, make one record per state.

You cannot make MapPoint do what it does not do... you have to make work-arounds yourself.

Eric
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
biz, importing, multiple, needed, single, states


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
Import data with Multiple states per record kwcarlberg MapPoint 2006/2009 Discussion 0 10-14-2006 08:58 PM
Importing multiple maps into Excel dadburne MapPoint 2006/2009 Discussion 5 10-19-2005 01:07 PM
c# ImportData method help needed fletch MapPoint 2006/2009 Discussion 8 03-09-2005 10:15 AM
Less Address Accuracy Needed(!) NickS MapPoint 2006/2009 Discussion 2 11-28-2003 04:39 AM
Zooming in to Multiple States Anonymous MapPoint 2006/2009 Discussion 2 07-16-2003 01:03 PM


All times are GMT -5. The time now is 03:08 AM.


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 55