-3

Suppose there are 5 worksheets for 5 tables in SQL Server, how do I write a single code to insert bulk data from this 5 sheets to 5 tables in SQL Server.

Dale K
  • 25,246
  • 15
  • 42
  • 71
Souvik Pal
  • 21
  • 3
  • Does this answer your question? [How to import an Excel file into SQL Server?](https://stackoverflow.com/questions/39610133/how-to-import-an-excel-file-into-sql-server) – Dale K Feb 18 '20 at 19:42

1 Answers1

-1

You can do that through SSMS import feature or run query.The question has already answered here :

How to import an Excel file into SQL Server?

Amin Pashna
  • 141
  • 1
  • 1
  • 6