I searched this but couldn't get a definitive

[JPnyc]

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.

[Ecniv]

The sticky post at the top for sql statements..

Insert Into <tablename> ( <field>,<field>,<etc> )
Select [Tablename].[fieldname],[tablename].[fieldname],[etc].[etc]
From [tablename]

Run one for each table.
Use VBA code to loop through tables to automatically copy... Note Auto fields may change values...


Vince

[JPnyc]

Thanks. I guess there's no tidier way to do it. I was hoping I could just select *, then somehow concatenate the recordset, or place it's entire string in variable, and into the insert statement. Of if there was a command that dumped all tables , that would've been best.

[visualAd]

Originally posted by mendhak
A small web-based (aspx?) or java-based chatroom, linked to from vbforums, so you log in with your own username+password, would be a good idea.

It'll be just like chit chat at a faster speed.

And just as bizzaar

[JPnyc]

Something tells me that post wasn't intended for this thread.

[visualAd]

That is spooky ... it was meant for this thread:

http://www.vbforums.com/showthread.p...77#post1802775

Indeeed I pressed the reply button on that thread, havn't seen this one until now, so how the reply got here is a mystery.

[JPnyc]

Well you know what they say, "Bit Happens".