Moving data from table to table

[Falin]

I have a table that contains a lot of data, and I am now creating new tables
to split the data up. How do I do to only get some of the data in the old
table to a new one? For example one or two columns.

 

[Rick Brandt]

I have a table that contains a lot of data, and I am now creating new
tables to split the data up. How do I do to only get some of the data
in the old table to a new one? For example one or two columns.

Check help for "Append query".

 

[Sunny]

SELECT Col1, Col2 INTO MyNewTable FROM myOldTable Where ifanycondition