Share via

ShowImportWizard method

  • Article

Opens the Import Data Wizard; similar to clicking Import Data Wizard on the Data menu. Returns a DataSet object if one is created. Returns Nothing if the user cancels out of the wizard.

Applies to

Collections:  DataSets

Syntax

object.ShowImportWizard([HWndParent], [DataSourceMoniker], [Delimeter], [ImportFlags])

Parameters

Part Description
object Required. An expression that returns a DataSets collection.
HWndParent Optional Long. Handle of the user's window, to allow the Import Data Wizard to be modal to a window in the calling application, rather than MapPoint.

Note  Do not use a handle for a window other than the MapPoint window if the MapPoint window is visible.
DataSourceMoniker Optional String. File name to import. Can also provide information on which part of the file to import. See the DataSourceMoniker syntax topic for the correct syntax to use for this parameter. If a file name is not specified, the user interface will prompt the user for a file to import.
Delimiter Optional GeoDelimiter. Characters that separate individual fields. Can be one or more characters. Required for importing text (.txt) files. Default is geoDelimiterDefault.
GeoDelimiter Value Description
geoDelimiterComma
44
 Fields separated by commas (","). Default for .csv files.
geoDelimiterDefault
0
 MapPoint determines the delimiter based on the file type.
File type Default Delimiter
.asc tab
.csv comma
.tab tab
.txt tab
geoDelimiterSemicolon
59
 Fields separated by semicolons.
geoDelimiterTab
9
 Fields separated by tabs ("\t"). Default for .tab, .txt, and .asc files.
ImportFlags Optional Long. Provides information about the DataSourceMoniker and the data in the file. Multiple values can be passed by using the Microsoft Visual Basic "Or" operator (for example, geoImportExcelNamedRange Or geoImportFirstRowIsNotHeadings).
GeoImportFlags Value Description
geoImportAccessQuery
4
 DataSourceMoniker specifies an Access query.
geoImportAccessTable
0
 DataSourceMoniker specifies an Access table. Default.
geoImportExcelA1
0
 DataSourceMoniker specifies Excel A1 syntax. Default.
geoImportExcelNamedRange
4
 DataSourceMoniker specifies an Excel named range.
geoImportExcelR1C1
2
 DataSourceMoniker specifies Excel R1C1 syntax.
geoImportExcelSheet
0
 DataSourceMoniker specifies an Excel worksheet. Default.
geoImportFirstRowIsHeadings
0
 First row of the file contains field names. Default.
geoImportFirstRowNotHeadings
1
 First row of the file does not contain field names.

Remarks

To import data as a DataSet object, use the ImportData method on a DataSets collection.

Example

  [Visual Basic 6.0]

Sub ShowWizard()
  Dim objApp As New MapPoint.Application
  objApp.Visible = True
  objApp.UserControl = True
  Dim objDS As MapPoint.DataSet

  With objApp.ActiveMap.DataSets
    Set objDS = .ShowImportWizard
  End With
End sub


[C#]

void ShowWizard()
{
  MapPoint.ApplicationClass objApp = new MapPoint.ApplicationClass();
  objApp.Visible = true;
  objApp.UserControl = true;
  MapPoint.DataSet objDS =
  objApp.ActiveMap.DataSets.ShowImportWizard(0,
    "",
    MapPoint.GeoDelimiter.geoDelimiterDefault, 0);
}

Example using parameters

  
    Sub ShowWizard()
  Dim objApp As New MapPoint.Application
  objApp.Visible = True
  objApp.UserControl = True
  Dim strFile As String
  Dim objDS As MapPoint.DataSet

  With objApp.ActiveMap.DataSets
    'Excel sheet
    strFile = objApp.Path & "\Samples\Sales.xls!Sheet1!A1:C22"
    Set objDS = .ShowImportWizard(, strFile, , geoImportExcelSheet)
  End With
End sub