susmitha117 (7/30/2014)

---

Hi,

I have a file which changes every week @C:\TEMP(data and filename both) schema remains the same all the time. I want to import this data to sql and save it to archive folder.

I will have only one file in temp as the executed file goes to archive. The folder becomes empty.

Please suggest.

I have tried for each loop for this but doesn't seem to work. I am using visual studio 2005 and my excel files are in 97-2003 version(.xls)