Sub button1_click
convert
end sub
Sub convert
SQL1.ExecNonQuery("CREATE TABLE CREW (s1 TEXT , s2 TEXT, s3 TEXT, s4 TEXT, s5 TEXT, s6 TEXT, s7 TEXT, s8 TEXT, s9 TEXT, s10 TEXT )")
Dim line3 As String
Dim i As Int
reader.Initialize(File.OpenInput(DBFilePath,FileName))
i=0
line3 = reader.ReadLine
Do While line3 <> Null
Dim CC() As String 'CC is column content
CC = Regex.Split(",", line3)
SQL1.ExecNonQuery2("INSERT INTO " & DBTableName & " VALUES (?,?,?,?,?,?,?,?,?,?)", Array As Object (CC(0), CC(1), CC(2), CC(3),CC(4), CC(5), CC(6), CC(7),CC(8),CC(9)))
i = i + 1
line3 = reader.ReadLine
Loop
Msgbox(i & " Records in text file were imported to ".ToUpperCase & DBTableName, "T E X T F I L E")
End Sub