[RESOLVED] Inserting Data into existing fields

[slaphead109]

I am using VB6, and can connect and extract data from fields using SQL. I can add New data to a table no problem.

How do I insert data into fields where data already exists? I will use a serial number to identify the row I need.

Thanks for any help.

[Shuja Ali]

You will have to use Update Statement.

Update TABLENAME Set FIELDNAME = 'data' Where Condition 

[slaphead109]

That works great.

Thank you for your help