sqlinterset (9/29/2015)
Currently i am using SQL Server 2012 Import/Export Wizard to upload data to sql tables manually. However i was trying to write a procedure to update that table. and on the time of execution, if i can pass excel. Is there any way to pass excel to stored procedure parameter?
You could always save the SSIS package which the wizard creates for you and enhance it.
You cannot pass a file as a stored proc parameter, though you can certainly pass the file's path.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel