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

date posted 25th January 2005 19:43

SELECT field1[, field2[, ...]] INTO newtable [IN externaldatabase]
FROM source

D.
-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Nicola
Dunn
Sent: 25 January 2005 18:58
To: FN-FORUM / [EMAIL REMOVED]
Subject: FN-FORUM: Another Access thing...


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.

Ta!

Nicola


=====
Nicola Dunn