MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




problem with IMPORT-method

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. ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-27-2003
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
problem with IMPORT-method

Hallo guys,

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)

.
.
.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 06-04-2003
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
importmethod, problem


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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


All times are GMT -5. The time now is 10:37 PM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54