i found an interesting source that would help me extract 2007 excel file and save it to SQL server 2005 using ASP.Net but i have encountered an error and i don't know how to solve it.
i used the vb file. And i got the error at this part if i'll use the excel 97-2003 worksheet
conStr = ConfigurationManager.ConnectionStrings("Excel03ConString").ConnectionString
and i got the error at this par if i'll use the excel 2007
conStr = ConfigurationManager.ConnectionStrings("Excel07ConString").ConnectionString
BTW, the error says: Object reference not set to an instance of an object.
your small help is a big help for me. Thank you!