THe only purpose in me doing this is to get my data in to sql so that I can start cleaning the old data up (It is a mess), and making the needed changes. The only time I would use this is a few times when I need to reupload data.

I am needing to import excel data into my program. I am using Visual Studio 2019 web development and my code behind runs VB. I would like to load data into gridview and from there into sql. I have a lot of work to do to clean up the data before my final product is ready. So I am wiring a routing to clean up the data. Anyone have an idea. I have been searching online but most of the options does not work. If you have the answer please also provide me with the imports statements I need.