taskman

Two suggestions: 1/ step through it with the debugger, and 2/ put a try/catch structure in there and place a breakpoint inside the catch block.

You may intend for it to be in a loop and return to the top? I use a 'while (true)' loop as a control structure sometimes, with 'break;' at appropriate places to kick it back to the top or out of the loop.

Setup an ODBC connection through the Control Panel - Administrative tools - ODBC. Make that work first. Then use that to replace the vast majority of what is in your odbcconectionstring. You have unnecessary elements in there that might be gumming things up, such as UID= and PWD with no …

It is probably an archive packaged in an .exe. Is there no readme.txt file on the disc that gives step by step instructions for installing this disc? I concur with SirMG that the problem is likely because you are trying to run this on the disc. Since discs are usually …

Just to clarify, you say: > BUT if I change the Avg or Colour field in the excel then a new record is inserted and not updated, can someone please help? So your problem is with this statement? > "UPDATE P SET Stock = T.Stock FROM prices P INNER JOIN …

Since you are trying to put input in out of context (with no particular UI element in focus), I would expect it to be a matter of putting something into the mouse buffer. Here is a page that may give you a starting place for tracking it down: [Click Here](http://msdn.microsoft.com/en-us/library/windows/desktop/ms682079(v=vs.85).aspx)

@cyberdaemon - if you solved the question you originally asked, it may help future readers to know what that solution was.