读取Excel文件并在SQL server中新建Table上传数据

First, you can read data  Excel Data into a Dataset: Code: Reading Excel Data into a Dataset (Visual Basic)

   Then you can create the table in SQL server using the DataSet. Sample here: HOW TO: Implement a DataSet CREATE TABLE Helper Class in Visual Basic .NET

   At the end, upload the data from the dataset to the created table.Sample here: How To Update a SQL Server Database by Using the SqlDataAdapter Object in Visual Basic .NET

Creating a SQL Server Database Programmatically