MavrickStl
Programmer
I am trying to use this code to Read .txt or .cvs files via VB6.0 and save the data into variables. And Later I want to import this data into an Oracle database. I have not written the Oracle part yet but my code is having problem reading the data from .csv , .txt files. Urgent help needed. csv and txt files contain multiple lines of data. Mavrick
I am getting this error when I run the code " Compile error:
User_defined type not defined"
Private Sub Command1_Click()
Dim FSO As New FileSystemObject
Dim tsInput As TextStream
Dim varData As Variant
Set tsInput = FSO.OpenTextFile("C:\TransgeneImpact\Test.csv", ForReading)
varData = Split(tsInput.ReadAll, ","
End Sub
I am getting this error when I run the code " Compile error:
User_defined type not defined"
Private Sub Command1_Click()
Dim FSO As New FileSystemObject
Dim tsInput As TextStream
Dim varData As Variant
Set tsInput = FSO.OpenTextFile("C:\TransgeneImpact\Test.csv", ForReading)
varData = Split(tsInput.ReadAll, ","
End Sub