Question: how to export data from excel to sql using vba?
Answer: Delete all data from a temporary import table. Export Excel data to the empty temporary import table. Update desired tables from the temporary import table data.