how to insert values from an excel sheet to sqlserver 2005
<p>i have an excel sheet where  i try to upload my excel sheet to sqlserver all  having same  colum name.
 now i do not want to add  dll  files as  an  web reference in my project.
 rather place the (dll) in an folder and call them dynamically in .cs  side.
now i am doing like this</p>

<p><strong>var assembly = Assembly.LoadFrom(@"d:\abc\microsoft.office.interop.excel.dll");</strong> </p>

<p>now in my .cs  page i need  to generate this property or methods  of an excel dll which i have  loaded dynamically</p>

<p><strong>microsoft.officce.interop.excel.applicationClass excel= null</strong></p>

<p>so that after loading my excel  dl  dynamically i need to sent values from my excel sheet to sqlserver  2005</p>

<p>is there a way to achive this
 thank you </p>
