Thank you for the prompt reply, I had read a little on oledbdataadapters and datasets, I need to look into that more.
I had even tried using an "Insert Into Table1 ....Select" statement, and executing it as a NonQuery, but that didn't work. I guess I need to find some example on...
I am currently writing a VB .NET application where I am trying to open 1 database, create a select statement and then post the results into another database file using Microsoft Access database 2002.
The code seems to stop executing at the statement "cmdJetDB.ExecuteNonQuery()"