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!

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, networking, learning, and sharing knowledge.