Linking Tables

  • Thread starter Thread starter trevorscampaign
  • Start date Start date
T

trevorscampaign

Could you please tell me how to copy data from one table
to another. I have a table of information containing
3,400 records. However, I want to pull 500 records from
this table and create a new table with just these
records. How would you suggest I do this?

I appreciate any help someone can give me. Thanks.

Kate
 
Kate,
You may run a Make Table query like this:

SELECT * INTO Table2
FROM Table1
WHERE (Your crteria goes here)

or simply if you need any 500 records

SELECT TOP 500 * INTO Table2
FROM Table1

You may add also ORDER BY clause to the queries if you want.
This may be especially helpful for the later query.

Hope this helps,

Alex.
 
Back
Top