I am using following Query for Insert record,
Value getting from Array List ( valuelist)
The problem is if record exist then its giving me error cause of primary key in database.
so now how can i update record
using update query
insert query working fine
but for update i am little confuse how it will work and how to get value .....
What update query will be
If valuelist <> "" Then
''''''''INSERTING DATA FROM CSV FILE'''''
con.Execute "insert into B_Detail (BtyNo,Mode,BDate,TkNo,Code,....etc 58 fields) values (" & valuelist & ")"
Kill "D:\Crystal\" & BNo & ".csv"
' valuelist = Empty