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.