Add DTS transfer to a button

[dom24]

HI,

Is it possible to record and add the DTS tool to a button so that it is run automatically when a user clicks it?
What I want to do is transfer data from an excel file to a temporary table in sql, then update another table with the records from the temporary table if any do not match.
However I will be passing this on to admin staff who have no experience in using sql server, therefore I wanted to adda button to the front end (created in access) which will automatically run it each time.
Is this possible, or is there an alternative?

 

[dyarwood]

Can you create something with the xp_cmdshell then have the "DTSRun /S "servername"..... in the xp_cmdshell string.

Not sure if this would work within Excel, I will have a play around with it.