Object reference not set to an instance of an object.

Question

Mits14 0 Newbie Poster

11 Years Ago

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!

asp.net

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with zip files.

ImportExcel2DB.zip (165.44 KB)

Edited 11 Years Ago by happygeek because: moved from asp to asp.net forum

2 Contributors
2 Replies
313 Views
23 Hours Discussion Span
Latest Post 11 Years Ago Latest Post by Mits14

JorgeM 958 Problem Solver

11 Years Ago

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

Reply to this topic

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.

Mits14 0 Newbie Poster · Answer 1 · 2013-01-12T08:11:35+00:00

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