Oracle/VB (Let's see if you really know)

I'm trying to import a tab delimited file in an Oracle table from VB 6.0. How do I do it? Email replies to [email protected]. If you answer, this you are the best VB programmer I know.

[Allen Noakes]

Here is the code you need:

Dim liIt As Integer
Dim lsTemp As String
Dim lsaTarget() As String


Open "d:\vbhelp\tabdel.txt" For Input As 1
Do While Not EOF(1)
Line Input #1, lsTemp

lsaTarget() = Split(lsTemp, Chr(9), -1, vbTextCompare)
For liIt = LBound(lsaTarget) To UBound(lsaTarget)
'
' Here is where you add your code to update your Oracle Database
'
Next
Loop

Close 1


Allen Noakes
VB Programmer/Analyst
Dames & Moore Group
[email protected]