SQL help Needed

[ELH]

Hi

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.Can anyone help with that?

Thanks

[Senthil]

Hi,

You can use the DTS for transformation and schedule it.

Cheers,
Sharmila

Hi

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.Can anyone help with that?

Thanks

[andy davis]

how do i make a dts package for backup of a table and can i import this package in java