0

hello,
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!

Edited by happygeek: moved from asp to asp.net forum

2
Contributors
2
Replies
5
Views
4 Years
Discussion Span
Last Post by Mits14
0

Did you update the web.config file with the proper DB settings after you restored the backup DB file that was provided?

0

thanks JorgeM for the reply..i didn't that's why i got that error.. it's now working fine. thanks

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.