Linking Tables

[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

 

[Alex Ivanov]

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.