subramani.rudrappa 78855 (11/16/2012)
Hey Hi,I know we can use SSIS to get data from excel and load in to SQL table from where i can achieve requirements.
I thought of using only SQL to get data from excel and achieve the requirements so that we need not to go for SSIS.
I'm not aware of a way to use SQL directly. That is why Microsoft developed SSIS.