Reply to thread

Message: [QUOTE="Tushar, post: 600123"] Hey, When I was using INSERT ( in the same fashion as u hv mentioned), each time I used to execute my DB, the existing DB would get appended with the same data again. Somebdy suggested to use UPDATE for inserting into DB. UPDATE will re-write stuff and not append the db. SInce I am using UPDATE to fil lin data into the DB, I can't use the WHERE clause ( coz the DB is Emply!) When I tried to update in the fashion I have posted before........it said Syntax error in UPDATE Command...... Whts the error. I am using Access DB [/QUOTE]