Re: FN-FORUM: Another Access thing...

date posted 25th January 2005 19:58

On Tuesday 25 January 2005 19:57, Nicola Dunn wrote:
> OK...
>
> I have Table A.
> Table A is the existing DB (yes, it's all in one table.)
>
> I want to split things, so I create Table B.
> Table B has 7 fields from Table A in it.
>
> How do I extract the data from Table A and shove it into Table B?
>
> Obviously I don't want to have to go through a million records
> (well... 500) and type things into Table B.
>

something like:

SELECT col1,col2,col3,col4 INTO NewTable FROM oldtable

Alternatively just copy the whole database and delete the columns you don't
need from the new copy.

r