Excel file to Existing azure sql database table

Question

I have an excel file that employees enter data in. I also have an sql database on azure. They have the same columns and column names. Is there an easy way for me to insert the data from the excel file into the existing table? I currently manage to do it through a series of steps: convert .xls to delimited file. Load file into sql management, insert into existing database by creating a new table, copy one table into existing table.

It is a lot of aggravating steps. Surely there is an easy way that I don't know of?!

Thanks!

Answer 1

If the columns as it don't change, only the data changes/get added, the you can use the Import/Export wizard to copy the XLS file content to (Azure) SQL Server.
See Steps in the SQL Server Import and Export Wizard

Answer 2

Hey,
On a side note you can also create a Azure data factory pipeline with copy activity copying data from Excel into Azure SQL database table.
Or even use an SSIS.