Is it possible to schedule the SQL database update?

[Botham Ruosh]

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.

[Rabbit]

SQL Server comes with SQL Server Agent, you can use it to schedule jobs.

[nitish7503]

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 tblCustomerDeta ils(nolock)
FROM OPENROWSET('Mic rosoft.ACE.OLED B.12.0',
'Excel 12.0; Database=C:\Exc el\Spreadsheet. xls; HDR=YES; IMEX=1',
'SELECT * FROM [Sheet1$]');

End