I have a VB.NET 2003 WinForm application. In it, it must copy some rows from one table to another identical table in an Access database. Is there an SQL query that will do this?
For example, if the source table is called Table1, and the destination table is called Tabled2, and I want to copy the rows that have an ID greater than 10 from the one table to the other table, I would do something like this:
sSQL = "INSERT INTO Table2 (SELECT * FROM Table1 WHERE ID > 10)"
However, this isn't working. Any ideas? If it can't be done with an SQL query, then maybe an ADO.NET sample code?