hi all,
can u tell me a good efficient way to transfer data from a text file(notepad...data is systematically arranged seperated by comma) into a excel sheet using VB6.

i have tried Opentext method... but i need a much better way to increase the effeciency for incase the file may have one lakh rows...something like that.

rajesh