How to automatically push data from Excel file to SQL Server?

Question

How can one push data from an Excel file into my SQL Server?

I tried to get data from the database into an Excel file but I don't know how to push the new data and the users won't click the button to push data every time.

So if someone knows how to sync a SQL Server database with the Excel files in order to get that data automatically, I would really appreciate it.

What @WEI_DBA said along with a SQL agent job (learn.microsoft.com/en-us/sql/ssms/agent/…) to automatically run that SSIS package. — Isaac
– Isaac, Commented Jul 30, 2019 at 12:58
@WEI_DBA what is that? That is the first time i read and hear about it — RagingDeathWish
– RagingDeathWish, Commented Jul 30, 2019 at 13:09
SQL Server Integration Services... Start here... learn.microsoft.com/en-us/sql/integration-services/… — SS_DBA
– SS_DBA, Commented Jul 30, 2019 at 13:23
Possible duplicate of How to push data from excel to SQL Server? — Pawan Gupta
– Pawan Gupta, Commented Jul 30, 2019 at 13:39

Pratik Bhavsar · Accepted Answer · 2019-07-30 12:59:20Z

0

I will look forward to two options in this scenario:

SSIS Package: Use SSIS package which picks up data from a specified path (your excel), which inserts new rows and updates existing ones. Schedule this package with SQL Job agent.

Console App: Write a simple c# console app, which does the same and schedules it using windows scheduler.

answered Jul 30, 2019 at 12:59

Pratik Bhavsar

8481 gold badge10 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

RagingDeathWish Over a year ago

Does the SSIS Package work on a local sql Server? Cause I use a local sql Server

Pratik Bhavsar Over a year ago

Sure it does, you just need to set up Integration Services on your local server: learn.microsoft.com/en-us/sql/integration-services/…

Collectives™ on Stack Overflow

How to automatically push data from Excel file to SQL Server?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related