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.
