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

Dim objrecordset as MapPoint.Recordset
Set objrecordset = objDataSet.QueryAllRecords

Now you can access: objrecordset.Fields.Item(n).Value


Hope is usefull.

Marvellous—just what I was looking for.
Thanks very much for your help.