Need help with coding

[__gini2]

I want to create a code in vb6 that will delete data from its database (Microsoft Access). The columns (attributes) in the database are CWNo, Name, IC No, Nationality, Company, Join Date and Expiry Date.
Then it will insert data from a Microsoft Excel Sheet that contains the same attributes above.

Can you please give me a hint on how I can do this? Maybe you can provide me with an algorithm or sth that will be useful for me to complete the task above.

[Bill Crawley]

You should be able to use the SQL Delete and Insert Statements on the Connection Object.

Delete from [table] where [ColumnName] = [YourValue]

Insert into [table] (column1, column2.....) values (value1, value2....)

Build a string with the value above and pass the string in on the Execute method of the connection object.