Hi,

I tried searching for this exception but couldn't find anything. I'm trying to import a list of airports into mappoint using C# and the call to import data throws an exception:

An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in MapPointTestApplication.exe
Additional information: Cannot import data because no columns were found.

Any help would be greatly appreciated.
Thank you,

Mitu

My Code:
DataSets dataSets = ActiveMap.DataSets;

object [,] arrFields = new object[7, 2];

arrFields[0, 0] = "Name";
arrFields[0, 1] = GeoFieldType.geoFieldName;
arrFields[1, 0] = "";
arrFields[1, 1] = GeoFieldType.geoFieldSkipped;
arrFields[2, 0] = "Latitude";
arrFields[2, 1] = GeoFieldType.geoFieldLatitude;
arrFields[3, 0] = "Longitude";
arrFields[3, 1] = GeoFieldType.geoFieldLongitude;
arrFields[4, 0] = "";
arrFields[4, 1] = GeoFieldType.geoFieldSkipped;
arrFields[5, 0] = "";
arrFields[5, 1] = GeoFieldType.geoFieldSkipped;
arrFields[6, 0] = "";
arrFields[6, 1] = GeoFieldType.geoFieldSkipped;

dataSets.ImportData(strFileName, arrFields, GeoCountry.geoCountryUnitedStates,
GeoDelimiter.geoDelimiterTab, GeoImportFlags.geoImportFirstRowNotHeadings);

And my file sample (tab delimited, 7 columns):

AAF US 29.733333333333 -85.033333333333 Apalachicola, FL America/New_York Apalachicola Municipal

I dont know if this is a problem or not, but when I import data sets, I create a dataset to import it into.

For example,

Code:

DataSet DS;

DS = dataSets.ImportData(strFileName, arrFields, GeoCountry.geoCountryUnitedStates, 
GeoDelimiter.geoDelimiterTab, GeoImportFlags.geoImportFirstRowNotHeadings);

That has always worked for me, but Ive never used a tab seperated file before. Also, and Im not sure about this either, but I think that when you use an array of fields, you are telling it what the name of the column you are importing from is called, so since you don't have any column names, that might be a problem.

Thanks for that suggestion! I added the column headings to the file and changed tabs to semicolons and it worked like a charm.

Thanks again,

Mitu