hi i am trying to fetch thousands of rows from the db (oracle) and
populate in excel sheet the process is taking lot of time. what i need
to do is fetch this rows in text file and than open text in excel which
i guess will take less time.. looking for some example code if some one
can help.

i am new to vb programming.

thankyou..

No, what you need is a little database connection assisted by ADO. See
http://tinyurl.com/zbswx
I do this all the time, and the process takes from 1 to 5 seconds, depending
on the complexity of your search.

HTH. Best wishes Harald


"ritu" skrev i melding
ups.com...
hi i am trying to fetch thousands of rows from the db (oracle) and
populate in excel sheet the process is taking lot of time. what i need
to do is fetch this rows in text file and than open text in excel which
i guess will take less time.. looking for some example code if some one
can help.

i am new to vb programming.

thankyou..