[DW]

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

[rod k]

insert into table2 (field1,field2,field3,...) select fieldcorrespondingtotable2field1,fieldcorrespondingtotable2field2,... from table1;

[DW]

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]