here the text file i need to grab
here is the database i need to follow the sequence
here is my Insert into SQL command code
For eg:
HINTS:
Pxxx (database field column name)
1,2,3....7 (sequence for text file i need to follow)
1 = 8.6182e-01 2 = 1.6626e+00, 3=-4.8683e+01, 4.................................
1 store in DB column P001
2 store in DB column P002
3 store in DB column P003
.
.
.
.
.
Like SQL code show above, any idea to modify my SQL?
here is the database i need to follow the sequence
here is my Insert into SQL command code
VB.NET:
StrSQL = "INSERT INTO NXP_AM1_ACU_DETAIL " _
& "(FromId,StationId,SerialNo, " _
& "SWBin,HWBin,SystemBinCode, " _
& "TestResult,P001,P002,P003,P004,P005) " _
& "VALUES ('" & UniqueId & "', " _
& "'" & Station & "', '" & aSQL.Count + 1 & "', " _
& "'" & aColumns(1) & "', '" & aColumns(2) & "', " _
& "1, '" & aColumns(3) & "', " _
& "'" & aColumns(4) & "', '" & aColumns(6) & "', " _
& "'" & aColumns(8) & "', '" & aColumns(10) & "', " _
& "'" & aColumns(12) & "')"
aSQL.Add(StrSQL)
For eg:
HINTS:
Pxxx (database field column name)
1,2,3....7 (sequence for text file i need to follow)
1 = 8.6182e-01 2 = 1.6626e+00, 3=-4.8683e+01, 4.................................
1 store in DB column P001
2 store in DB column P002
3 store in DB column P003
.
.
.
.
.
Like SQL code show above, any idea to modify my SQL?
Last edited: