Load Excel | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Load Excel

I am loading an excel file into sql table using sql DTS, which is a sheduled job. My job is looking for test.xls and that excel file has test20060301 as sheet1 and the name of the sheet1 will be changing every day according to date, because of which my sheduled job is failing to load. How can I resolve this so that my DTS job loads the file though the name of the sheet is changed. Thanks!
"He laughs best who laughs last"