answer. I need a relatively quick, painless SQL statement for taking selecting * data from * tables in a DB, and placing all the data into another DB, which is already configured exactly as the one it's coming from. Same table names, same field names, same data types. So my question is, do I have to do select * and then insert value statements for each table? Or is there some group dump command I'm not aware of?

Also, in VB6, how do I get the entire record of table A, into the insert statement for table B? Do I place the rs.Recordset into a variable? Thanks much in advance, for any help.