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.