I have problems using ImportData. Somehow the call of ImportData fails
Please help!

Dim oMP, oDSSMP, oDSMP
Set oMP = GetObject(, "MapPoint.Application")
Set oDSSMP = oMP.ActiveMap.DataSets

' geoFieldName = 1
' geoFieldName2 = 2
' geoFieldAddress1 = 3
' geoFieldCity = 6
' geoFieldPostal1 = 11
' geoFieldCountry = 15
' geoFieldInformation 22
' geoFieldData 23
Dim myExampleArray(3, 2)
myExampleArray(1, 1) = "Name"
myExampleArray(1, 2) = 1 'geoFieldName

myExampleArray(2, 1) = "Vorname"
myExampleArray(2, 2) = 2 'geoFieldName2

myExampleArray(3, 1) = "Land"
myExampleArray(3, 2) = 15 'geoFieldCountry


Set oDSMP = oDSSMP.ImportData("C:\Temp\export.txt", myExampleArray, , 9)

Hi,

What exacly fails, what is the error, is there an exception raised ?

The Code is:

800A0FC6

"Data could not be imported, columns not found" (translated from german message)

Set oDSMP = oDSSMP.ImportData(sMyFile, myExampleArray, 39070, 9, 1)

Last Parameter means geoImportFirstRowNotHeadings

But the first row consists of column headings, doesn't it?

(and if it doesn't, how are you telling it what each column is?)

Richard

Originally Posted by Winwaed

But the first row consists of column headings, doesn't it?

(and if it doesn't, how are you telling it what each column is?)

Richard

No -> i use the array to tell him what columns exist in that file.

Regards

Pit

Can you post a sample of the export.txt text file as an attachment?

Eric

Dim myExampleArray(6, 1)

myExampleArray(1, 1) = 1 'geoFieldName

myExampleArray(2, 1) = 2 'geoFieldName2

myExampleArray(3, 1) = 15 'geoFieldCountry

myExampleArray(4, 1) = 6 'geoFieldCity

myExampleArray(5, 1) = 3 'geoFieldAddress1

myExampleArray(6, 1) = 11 'geoFieldPostal1

Set oDSMP = oDSSMP.ImportData(sMyFile, myExampleArray, 39070, 9, 1)

Are you able to import it using the regular MapPoint interface / wizard?

I've never imported fixed width text, only CSV or comma-separated.

Can you convert to CSV and see if that helps it to work?

By the way, this is my 2,000th post!

Eric

Hi Eric!

Thank you for your help!!

Yes i can import the file directy using the wizard.
The columns are not fixed, they are separated by TABs

Pit

Just want to be sure - it is working for you now?

What did you do? Switch to CSV?

Eric