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

date posted 25th January 2005 20:09

(Using Access 2000)

If you want to simply split 'columns' out into a new table e.g. personID,
memberID
then create a new query against your base table and populate the datasheet
with the desired
field names, then change it from a Select query into a MakeTable query, and
run it (having
specified the new table name).

I expect older versions will be similar, but I only know A2K.

Obviously, ensure you have backed up and compacted the database first -
maybe play with
your own private copy first?

Regards, Graham

----- Original Message -----
From: "Nicola Dunn" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Tuesday, January 25, 2005 6:57 PM
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
>
>