Storing data in excel sheet

[Saket]

where exactly you get a Run error? can you paste whatever you have tried?

---

OK, I think I got it, you getting error at msgbox statement. right?
Msgbox will not be able to prompt the null so in that case use

Code:

if rs.Fields("USER_NAME").Value <> Null then msgbox rs.Fields("USER_NAME").Value