I'm having problem with import excel file automatically into the database using SQL, i know that we can import the file manually from SQL.
However, i want it to run automatically.
That's why i am trying to write a store procedure to do that but i am having some problems.is it possible?
In SQL Server 2000 you should use Data Transformation Services
In SQL Server 2005 you should use SQL Server Integration Services
DTS and SSIS packages can then be scheduled to run automatically whenever you need them.