MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




problems with reading in excel files in Mappoint 2006

This is a discussion on problems with reading in excel files in Mappoint 2006 within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hello All, I have a question regarding the reading-in of excel files in MapPoint 2006.I have been encountering a problem ...


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 (3) Thread Tools Display Modes
  3 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 07-17-2008
Junior Member
White Belt
 
Join Date: Jul 2008
Posts: 3
problems with reading in excel files in Mappoint 2006

Hello All,
I have a question regarding the reading-in of excel files in MapPoint 2006.I have been encountering a problem heren some occasions Mappoint refuses to read(and display) all the columns in the excel file in the import data wizard, while on other occasions it reads in the entire file. Can someone please tell me how to fix this problem?

Murali
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-17-2008
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,382
Blog Entries: 1
Re: problems with reading in excel files in Mappoint 2006

Can you post an example where it does not read all the column names?

I am wondering if there is an empty column. When MapPoint sees an empty column maybe it stops looking for additional columns.. ?
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
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-17-2008
Junior Member
White Belt
 
Join Date: Jul 2008
Posts: 3
Re: problems with reading in excel files in Mappoint 2006

Hi Eric,
I have about 14 different columns in my dataset, none of which are empty(though they do have some missing values).What is puzzling to me is that sometimes it manages to read all of the columns in, but ignores abt half of the columns at other times.

Murali
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-17-2008
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,382
Blog Entries: 1
Re: problems with reading in excel files in Mappoint 2006

I wonder if there is some column name that is causing it to react, or something else.

Have you been able to isolate the problem?

Can you post it or a sample?

Eric
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5 (permalink)  
Old 07-17-2008
Junior Member
White Belt
 
Join Date: Jul 2008
Posts: 3
Re: problems with reading in excel files in Mappoint 2006

Hi Eric,
i was able to solve the problem by converting the file from the xls to the csv format and then reading it in to MapPoint, which now seems to recognize the full dataset.thanks for ur help.

Murali
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
excel, files, mappoint 2006, problems, reading


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/problems-reading-excel-files-mappoint-2006-a-8066.html

Posted By For Type Date
Spatial Data Importer Contest Submission - MP2K Magazine This thread Refback 07-21-2008 12:13 PM
MapPoint Download - MP2K Magazine This thread Refback 07-18-2008 05:59 AM
2006: Blogs, Photos, Videos and more on Technorati This thread Refback 07-18-2008 12:00 AM

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
Mappoint 2006, C#, VS 2008, Vista, COM object problems jovo Development 7 3 Weeks Ago 05:22 PM
Update MP 2004->2006 // Now Problems with VBA-Excel-Makros... 50miles/100miles... Maik1976 Development 0 06-19-2008 07:52 AM
Cannot Import Excel Files GKing MapPoint 2006/2009 Discussion 6 08-04-2007 04:54 AM
Problems exporting MapPoint data to Excel in embedded map o0beaner MapPoint 2006/2009 Discussion 4 03-12-2007 02:14 PM
can´t import excel files Anonymous MapPoint 2006/2009 Discussion 2 03-18-2004 02:02 AM


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

Cheap flights to Majorca
Majorca has got a little something for everyone. As well as the legendary nightlife there are historical areas to explore. Check it out!

Travelcounselors
TravelCounsellors are a Queens award winning Travel Agent. Have a personal Travel Counselor help with your travel plans.

Holiday Italy
A Holiday in Italy can mean many different things to many different people. This diverse country has an abundance of art, wine, food and stunning beaches. Book online today.

Holidays to Dominican Republic
Holidays to Dominican Republic offer a wealth of natural beauty and magnificent views. Come alive in the splendor of the Dominican Republic!

Holidays
For bargain holidays to destinations including Mexico, South Africa, India and more, visit ULookUBook online today. Check out our free travel guides to help you make an informed decision for your holidays.

Inclusive package holidays
Choose one of the many inclusive package holidays at Travel.co.uk and save a lot of trouble and money too!

Holidays in Cyprus
Visit the tombs of the island kings! Visit On The Beach for information on holidays in Cyprus.


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