423,485 Members | 1,664 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,485 IT Pros & Developers. It's quick & easy.

Is it possible to schedule the SQL database update?

P: 1
Hi All,

We have a program which will generate output dynamically, after each minute, in excel files, the requirement is to upload these files to SQL database automatically.
Is it possible for SQL server to pick the files from a specific folder and write the database tables after each minute?

Thanks in advance.
2 Weeks Ago #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,266
SQL Server comes with SQL Server Agent, you can use it to schedule jobs.
2 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.