dim rst as dao.recordset dim query as string query = "select sname,scity from smaster" set rst = oconn.execute(query) dim i as integer i = 1 do while not rst.eof Sheet1.Cells(i, 2) = QueryRs("sname") Sheet.Cells(i, 1) = QueryRs("scity") i +=1 loop I think this will work (haven't tested it dough)

Follow the link for 8 or 9 possible methods, including code samples. http://support.microsoft.com/kb/247412/EN-US/[^] Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

Hi, I think the following URLs are useful to you. http://www.wilsonmar.com/ http://www.techiterviews.com/ http://www.mercury.com/(clikc white papers) http://www.winrunnerconsultants.com/ http://www.fundoosite.com/interview-questions/details.asp? http://chrisbrown.info/1winrun.htm Cheers

This is what i am already doing. I need a solution like by clicking a single button it has to export the data by executing the query in db. Tech_spidy

Try starting here: http:\\asp.net http:\\aspnet.4guysfromrolla.com Mark, http://aspnetlibrary.com

As its your project, its up to you to gather the requirements for the mail room, we can't help you with that! Once you've started coding and come up with problems then we might be able to help.

Not much idea.. Googled It[[^](http://Googled It)] Cheers Navaneeth!! www.w3hearts.com

Check this article[^] Hesham A. Amin blog

thanks for ur hint Sam Heller Tech_spidy

thanks for ur response krish. but i m using sql server for this wat navaneeth suggested is working exactly . regards:) Tech_spidy