Insert data from EXCEL to a table in SQL SERVER


I have a sheet in Excel 2016 that contains several columns with information about my clients; the file path is "D: \ Clients.xlsx".

Then I have a table "tb_clients" in the Database "bd_comercial" (SQL Server 2008 R2) with the same names, order, and number of columns as the Excel file.

What I would like to know is if, through a query, I can insert the data that appears in the Excel file to my table in SQL Server automatically, every day 1 of every month.

Over there they told me that it can be done through a Job, I hope you can help me. Thanks.

asked by Héctor Aucasi 21.05.2018 в 00:00

1 answer


I believe that the correct and simplest way to do what you need is through SQL Server Integration Services (SSIS).

There you could define the load of the data, some transformations that you require and later automate the periodic load through the SQL Server Agent.

If you do not know the tool, this guide could guide you initially: link .

answered by 04.06.2018 в 21:53