Using Excel in VB6

[Honsolo]

I have tried to get the ADODC in VB to connect to Excel and I can get it to connect. I like using the standard data1 data control because I can connect it so easily to text files. Is there a control (even third party) that is as easy as the data1 control that comes with VB. All I can find now is to open an excel file in excel and manually set each text file to each cell in the excel file. That would take months of programming for this program. There must be an easier way.

[Spoo]

Hon

When you say "text files", are they CSV (ie, comma delimited data) files?
If so, are you just trying to write some VB code to extract said data and populate Excel?

Spoo

[Siddharth Rout]

that is as easy as the data1 control that comes with VB. All I can find now is to open an excel file in excel and manually set each text file to each cell in the excel file.

If my understanding is correct then you can direct interact with Excel and open the text files (CSV) from vb6 rather than populating each cell from text file.

I would suggest that you go through this tutorial by Si to interact with Excel then also see THIS on how to work with CSV Files using .OpenText.

Hope this helps...