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!

Recommended Answers

All 2 Replies

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.