• 1k
  • 616
  • 509

How to save excel data in sql dynamically

May 15 2024 10:06 AM

If in SQL we created a table with 10 columns with column names col1 col2...col10.Now we take any Excel that has data in 10 columns, but the column name is different.

how do I do this? What I'm saying is that I will create a table in SQL only once, and in that table, I should save any Excel data, even though the column names are different. I hope you understand .Thanks in advance

Answers (1)