Import data from Excel to SQL Server automatically for every 15 min of time using MS Task Scheduler

Question

How can I import data from Excel to SQL Server using MS Task Scheduler

Google helps occasionally: https://learn.microsoft.com/en-us/sql/relational-databases/import-export/import-data-from-excel-to-sql?view=sql-server-2017#linked-servers or: https://community.powerbi.com/t5/Power-Query/best-way-to-push-data-from-excel-to-sql-server-no-of-rows-keep/td-p/107182 — droebi, Oct 30 '19 at 11:36

score 0 · Answer 1 · edited Oct 30 '19 at 07:35

0

Create a stored procedure with Bulk Insert in SQL Server. In Bulk import query itself you can specify the file location and Table structure. Refer this link for Bulk insert
Create a batch file and call the stored procedure using SQLCMD command. Refer this link for Example
Task Schedule the batch file using windows task scheduler. Refer this link

edited Oct 30 '19 at 07:35

Dale K

answered Oct 30 '19 at 07:08

Shriram R S

1 Answers1