>I am trying to find the fastest way to move data from one table to another. Both tables are almost Identical except the table recieving data has one extra field that has a default value which generate a unique id. Each table contain almost 85 fields or so but for simple example the following table fields have be reduced. Heres what I want to do:
>
>table1 contains data that I want to move
>field B
>field C
>field D
>
>
>table2 is where I want to recieve the data from table A
>
>field A
>field B
>field C
>field D
>
>how can I move table1 fields B thru D into table2 fields B thru D. In reality I have both table with approx 85 fields and I want to find a way of moving data maybe without defining every single field in table1 in the insert statement. Help appreciate
>
>
>thank
>nick patel

Did you try APPEND FROM ?