October 26th, 2000, 01:12 AM
-
Table one has a lot of data in it. Table two has the structure that I would like to use. How do I get the data from table one into table two quickly?
thx in advance.
DW
October 26th, 2000, 07:18 AM
-
insert into table2 (field1,field2,field3,...) select fieldcorrespondingtotable2field1,fieldcorrespondingtotable2field2,... from table1;
October 26th, 2000, 11:44 AM
-
Thank you, Rod, for getting me on the right path -DW
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by rod k:
insert into table2 (field1,field2,field3,...) select fieldcorrespondingtotable2field1,fieldcorrespondingtotable2field2,... from table1;[/quote]