I have an excel sheet [image] The table name should be the sheet name. And all the data of excel file have to be inserted into the table. And my excel file will be dynamic. Always the sheet name is not same.

How to Create a dynamic table in SQL Server from excel file and insert the data in the table

ynm_Sruthi (ynm Sruthi) December 22, 2021, 9:51am 3

is it only the sheet name that will differ? What about number of columns?

If only the sheetname is dynamic. Refer this post.

Regards,
Sruthi YNM

Topic		Replies	Views
How can i create a table in sql server from excel file using UIpath and insert the same excel data? Help excel , database , uiautomation , studio	13	4866	October 28, 2022
How to read data from excel then create table in sql database using excel column of excel file & insert data into that table Certification	2	1615	July 23, 2020
Read data from excel sheet dynamically and push to SQL Help	25	4488	October 23, 2019
Data table to SQL Table Studio	2	1286	April 29, 2022
Create Staging table in SQL using Execute Non Query Help datatable , database , activities , question	3	1274	March 8, 2023