473,385 Members | 1,409 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Is it possible to schedule the SQL database update?

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.
Sep 28 '18 #1
2 2664
Rabbit
12,516 Expert Mod 8TB
SQL Server comes with SQL Server Agent, you can use it to schedule jobs.
Sep 28 '18 #2
You can create a scheduler in User Agent.

Exec usp_exportdata

it will automatically replace previous data in Excel file.


Create proc usp_exportdata
As
Begin
SELECT * INTO tblCustomerDetails(nolock)
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0; Database=C:\Excel\Spreadsheet.xls; HDR=YES; IMEX=1',
'SELECT * FROM [Sheet1$]');

End
Nov 29 '18 #3

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

Similar topics

4
by: James | last post by:
I'm stuck. I have created a console application that does its job of collecting the data I want it to however I am stuck on writing this data back to a database. All of the examples I have been...
13
by: Lyners | last post by:
I have a web page writen in ASP.NET that contains some javascript so that when a user presses a button, or edits a certain field in a datagrid, another cell in the datagrid is filled with a value....
0
by: FST | last post by:
Hello All, Why does the database update from inside the Button1_Click event, but won't update from inside the DataGrid1_CurrentCellChanged event when I change cells? The message from inside the...
3
by: Pierre | last post by:
Hi, I was wondering if anyone ever done a progress bar that reflects a database update. I have an update query with SQL server that takes about 5 minutes. I can't figure out a way to show the...
1
by: gjiang_usenet | last post by:
Hi, Recently, I got a new client running DB2 UDB EE V7 on Windows 2000. (I am not a Windows guy and do not like it at all.) I found that this database is backed up (online) daily. However, I...
2
by: MirzaSila | last post by:
I have a form whitch record source is one of the tables I have in my database.I have various text fields on that form whitch control sources are table fields.When I'm inputing text into these text...
1
by: MFayaz | last post by:
Hello! I have to refresh datagridview when database update , IS there any way to solution that my datagridview auto refresh when any user update database. Thanks in Advance
1
by: psenthileee | last post by:
hi friends, tell me the database update through dataset or datatable using ADO.NET
1
by: tvnaidu | last post by:
Scripts with extension .lua for database update/restore - what language it is?, I can see some functions like C, but not C lang, any idea?
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.