Selecting Multiple Records

S

Scott

Hello,

I have an easy question that I can't figure out. I have a table of 200,000
records. I want to select records 1-50,000 to copy and paste into another
table.

What's the best way to select the 50,000 records? I'm currently selecting
record 1 and then hitting page down way too many times. There has to be an
easier way to do this.

Thanks in advance,
Scott
 
N

Norman Yuan

It could be easily done by run a "SELECT...INTO..." Query:

SELECT TOP 50000 Filed1, Field2, Field3,... INTO myNewTable FROM
theHugeTable WHERE .... ORDER BY ....

The SQL query will create a new table called "myNewTable" and garb first
50000 rows from rows in table "theHugeTable", according to the WHERE and
ORDER BY clause.
 
Top