Moving data from table to table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Falin - 03 Jan 2005 10:39 GMT

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.

Reply to this Message

Rick Brandt - 03 Jan 2005 12:43 GMT

> 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".

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Sunny - 03 Jan 2005 16:55 GMT

SELECT Col1, Col2 INTO MyNewTable FROM myOldTable Where ifanycondition

> 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.

Reply to this Message