I export (programmatically) from excel to mappoint.
There are, say, four fields: Order number; Name; Postcode; week number.
This maps fine.
I am trying to associate the week number of each record with a pushpin symbol number.
How do I use or access the individual records in the fields?
I have thoroughly searched your Q &A, picked up many tips, but no clues to solve this problem.
I am fairly new to programming.
I have tried to adapt this code but can only get field names.
Using Mappoint 2004, Excel 2003, VB.NetCode:Sub GetAllFieldNames() Dim objApp As New MapPoint.Application Dim objDataSet As MapPoint.DataSet Dim objFld As MapPoint.Field Dim strFldNames As String 'Set up the application objApp.Visible = True objApp.UserControl = True 'Let user create a data map objDataSet = _ objApp.ActiveMap.DataSets.ShowImportWizard 'Loop through all available fields for their names For Each objFld In objDataSet.Fields strFldNames = strFldNames & objFld.Name & vbCrLf Next MsgBox "DataSet field names: " & vbCrLf & strFldNames End Sub
Many thanks