Split a table

[bobi123]

Hello,



please help me with this problem...

have a table with 1.000.000 records, and I would like to put them into excel file, so first i would like to split the table into 4 equally big tables then export it into excel. I know how to export I just need help with splitting the 1 table.

example of the table1, three columns:

I Name I Surname I Phone I

can someone help with SQL? I am thankfull alot for the help!thank you!!

[bobi123]

I have access 2007

[JoeM]

If you add an Autonumber field, then each record should have an identifier from 1 to 1,000,000.
Then, you can create a query and place criteria on your Autonumber field to just pull out the subset you want. As matter as fact, if you make this a parameter query, it will prompt you for the numbers at run-time, i.e. place this as the criteria under the Autonumber field in your query:

Between [enter lower limit] and [enter upper limit]

Then when you run it, if you enter 1 for the first prompt and 250000 for the second prompt, it will return the first 250000 records.