vb6 and sql

im asking the database to return me a table.

how can i save each row and pass its records to another table ?

int other words: how can i take one table and copy it to another table ?

Moved to Database Development

Welcome to the forums. :wave:

Try something like

Code:

---

INSERT INTO NewTable SELECT * FROM OldTable

---