>>
>> Set oFox = Nothing
>>
>> Screen.MousePointer = vbDefault
>>End Sub
>>
>>Private Sub Form_Load()
>> Dim strOpen As String
>> Set oFox = CreateObject("weapondata.WeaponData")
>>End Sub
>>
>>
>>This needs to run unattended as the live data files will be large (about 400M) and the import process will require several hours.
>
>You stated you used the following syntax:
>
>sParams = "Do LoadData With " + sSourceFile + ", " + sDataPath + ", " + sTableName
>.DoCmd (sParams)
>
>I don't see how the above code ever worked since LoadData is a method. Try the following syntax from VB:
> oFox.LoadData(sSourceFile,sDataPath,sTableName)
>
>Murray
Didn't mean to indicate the code shown worked. I ported my development code ove to the runtime environment and it didn't work. I then proceeded to make what I thought were logical changes. They didn't work. Then tried the less logical ones. One of those is above.
Appreciate the note, will try it out and let you know how I finally get the thing running.
Again, thanks for the assistance.
Jim
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only