export records

[Octet32]

I have a table that has 10000 records I need to break this down into 2500
records each to export these records into a Excel spread sheet. Is their a
Marco that can do this?

Right now I search the table for record number 2500 then I highlight the
2500 cut and paste into excel is there a easier way to do this?.

 

[Steve Schapel]

Octet,

It sounds like you have a number field in the table that is strictly
sequential from 1 to 10000. Is that right? You can use queries to get the
records you want for each iteration.

SELECT TOP 2500 *
FROM YourTable
ORDER BY YourRecordNumber

SELECT TOP 2500 *
FROM YourTable
WHERE YourRecordNumber>2500
ORDER BY YourRecordNumber

SELECT TOP 2500 *
FROM YourTable
WHERE YourRecordNumber>5000
ORDER BY YourRecordNumber

etc