Extracting certain rows to excel

[brites]

Hi there, I have a table with 225.000 rows, I want to extract them 65.000 by 65.000 to an excel spreadsheet.

I dont have any numbering fild to help me. I got the first 65.000 with the instruction:
SELECT TOP 65000 * FROM TABLE_NAME,

How can I extract rows 65001 to 130000 and so on?

Thanks in advance!

Brites

 

[SydneyGeek]

Try putting square brackets around the table name:

"[Kroger Pos]" instead of "Kroger Pos"

Spaces in table and field names are often a cause of problems; it's best to avoid using spaces and either run the names together, or use underscores instead of spaces.

Denis