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.
Printable View
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.
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]