Importing Excel data to a already established SQL DB visual basic -

I have developed a program in which all data is entered in SQL DB. The program is designed in Visual Studio using Visual Basic. Now I am providing external data in an Excel format and need to import Excel data in SQL DB and ensure that the data goes into the appropriate column is. I have prepared a template for them with standard excel headers and I look at the data in a datagrid visit before importing, but the last part which is an import function for SQL I have not worked yet.

Any help would be most appreciative

Do you have a specific problem?

Using SSIS to import a better bet data can be done to do SSIS.