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.