Philip-1144230 (1/10/2013)
Disregard the previous question, answer is located here:Would you consider SSIS to be a better practice?
I would not put much stock in that post. The suggestion that macros are somehow safer than accessing a Worksheet using the Excel object is unfair. They are both dangerous. As I said in my previous post I would not want to host this operation on the server hosting my databases. Steer the requirement provider towards putting this onto an application server and keep it away from and out of SQL Server.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato