I have a DTS package that I created in Enterprise Manager that imports data into a table from an Excel spreadsheet. When the spreadsheet is open, if I right click and execute the task in the Local Packages interface it runs fine but if I use the query analyzer the task fails because it says the Excel spreadsheet is opened exclusively by another user.

use master exec xp_cmdshell 'dtsrun /S /E /NATP'

Is there any way around this because I need to execute this statement using ADO from Excel while the spreadsheet is open

Thanks!