Community of VE/MapPoint Users and Developers
This is a discussion on problem with IMPORT-method within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hallo guys, i got a serious problem while importing data using vba (com-object). import without the parameter ArryOfFields works fine. ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| |||
| problem with IMPORT-method i got a serious problem while importing data using vba (com-object). import without the parameter ArryOfFields works fine. any ideas ? thanks in advance. mark (mark.pfizenmayer@web.de) Code ==== Public objDataSets As MapPointCtl.DataSets Public objDataSet As MapPointCtl.DataSet . . . Public Sub procDatenImport(sDateiname As String, _ sKennzahlName As String, _ sFeld() As String, _ iFeldTyp() As Integer, _ iDarstellungstyp As Integer) Dim varFeld() Dim iAnz As Integer Dim iLoop As Integer iAnz = UBound(sFeld) iAnz = 1 ReDim varFeld(iAnz, 2) For iLoop = 1 To iAnz varFeld(iLoop, 1) = sFeld(iLoop) 'Fieldname varFeld(iLoop, 2) = iFeldTyp(iLoop) 'geoField... Next iLoop Set objDataSets = mapKarte.ActiveMap.DataSets ' at this method i got the message "incorrect parameter" (german: "falscher parameter") Set objDataSet = objDataSets.ImportData(sDateiname, varFeld(), geoCountryGermany, geoDelimiterTab, geoImportFirstRowIsHeadings) . . . |
| |||
| solution
Solution ... >For iLoop = 1 To iAnz > varFeld(iLoop, 1) = sFeld(iLoop) 'Fieldname > varFeld(iLoop, 2) = iFeldTyp(iLoop) 'geoField... => wrong: iFeldTyp = Integer => right: iFeldTyp = Variant/Long >Next iLoop |
![]() |
| Tags |
| importmethod, problem |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problem with dataset.QueryShape Method | Ray Liu | MapPoint 2006/2009 Discussion | 1 | 07-15-2004 11:55 AM |
| import query with importdata method in VB.net | Anonymous | MapPoint 2006/2009 Discussion | 3 | 01-20-2004 11:30 AM |
| Problem method Map.copymap() in visual basic .net | Anonymous | MapPoint 2006/2009 Discussion | 2 | 10-28-2003 03:05 AM |
| Problem with the optermise method | Anonymous | MapPoint 2006/2009 Discussion | 0 | 07-14-2003 10:06 AM |
| Import method | Anonymous | MapPoint 2006/2009 Discussion | 1 | 05-28-2003 04:41 AM |