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.
Code:
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
Using Mappoint 2004, Excel 2003, VB.Net
Many thanks