Using Excel and Access in a project

Aug 28 2007 4:22 PM
Hi,
I'm using Access and Excel as data sources in a project. I've been able to make the connections to both and have populated a dataset with the data. I end up with 4 tables in my dataset, three from Access and one from Excel.
Once I finish building the dataset I need to insert a column into the 'Excel' table (which is now a data table in my dataset) with one of the related columns retrieved from the Access db. I initially use two separate connection strings (and connections) to retrieve the data. Do I need to open a new connection, dataAdapter or what to work with the dataset?

I recently finished a college course onVB.net and would like some help with a few concepts.

Thanks, Dave