MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Newbie Question - Importing XLS data

This is a discussion on Newbie Question - Importing XLS data within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hi, Newbie here. Are there any examples out there of importing XLS data into a VB mappoint App. All 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 Thread Tools Display Modes
  #1 (permalink)  
Old 02-08-2004
Junior Member
White Belt
 
Join Date: Feb 2004
Posts: 3
Newbie Question - Importing XLS data

Hi,

Newbie here.

Are there any examples out there of importing XLS data into a VB mappoint App.

All i am trying to do is create an app with the VB control. When i click on a button it will load data (Postalcode and associated numeric data) and then display it on the map.

I am having a hrad time getting this to work just from the help files. Does anyone have some sample code or a sample project they could share?

Any help would be great!!!

Thanks,

Messier
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 02-09-2004
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
You can automate the import from excel procedure.
If you are using vb.net you can try this. Create a button that fires this code:

Code:
Sub ImportFromExcel

        'start new instance of mappoint
        Dim objApp As New MapPoint.Application
        Dim objDataSet As MapPoint.DataSet

        'Set up the application
        objApp.Visible = True
        objApp.UserControl = True


        'Let user create a data map
        'This opens the import wizard. 
        'You can then choose an excel file.
        objDataSet = objApp.ActiveMap.DataSets.ShowImportWizard()

        'This just helps demonstrates the example
        Dim oBox As MessageBox
        oBox.Show("Quit", "Quit")
    

        objApp.Quit()
       
 End Sub
You should be able to adapt this.
Hope this is of some use.
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, newbie, question, xls


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
GPS Newbie question Anonymous MapPoint 2006/2009 Discussion 7 11-14-2007 02:32 AM
newbie question xmikexx MapPoint 2006/2009 Discussion 2 11-06-2004 12:05 PM
MapPoint 2k4 Newbie question Anonymous MapPoint 2006/2009 Discussion 1 08-05-2004 05:21 PM
Newbie question Anonymous MapPoint 2006/2009 Discussion 1 05-28-2004 03:54 PM
GIS Newbie Question topak2000 MapPoint 2006/2009 Discussion 1 09-15-2002 01:38 PM


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


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