Importing data from Excel to MS SQL using C#?

Question

excel

I want to unload the data from Excel to MS SQL in a certain base by the button. This is done manually using the Import and Export Data tool. Is there any way to do this programmatically? I dug all over Google, but everywhere they write that tables are created first, and then data from Excel is already there, but this option does not suit me very well, it is necessary that tables be automatically created when importing data as when calling the import tool.

Answer 1

Perhaps integration services will suit you , in fact the same import, but with the possibility of programming :)

Answer 2

start with bash