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

date posted 25th January 2005 20:06

INSERT INTO TableB(fld1,fld2,fld3,fld4) SELECT fld5,fld6,fld7,fld8 FROM
TableA

I think that syntax is right.

Dave.

__________________________________________________
Dave Boulden, Director. DA Media Limited
web: http://www.da-media.co.uk/
Tel: 01795 559456 Fax: 07092 011488



> -----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
>
> --------------------------------------------------------------
> -------------------------
>
> "For as long as space endures, And as long as living beings
> remain, Until then may I too abide, To dispel the misery of
> the world."
>
> H.H. 14th Dalai Lama quoting Shantideva
>
> --
> Freelancers, contractors earn more with Prosperity4 Call 0870
> 870 4414 or visit www.prosperity4.com and benefit from Inland
> Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>