Yes Rich, I spent days trying to crack this and in the end had to cut my losses and battle the SSIS import which in itself proved ridiculously difficult. This...
Yes its so much simpler, but I came across an issue opening Excel on the server in that there is no known way to close the application afterwards and the...