Microsoft Access Help.....please :)

[bunker]

Let me preface this by saying if it were in SQL server I would have no problems, I hate Access!!!

I've got a table with 40k records and I need to split it up into eight 5k record tables for an operation I have to run on the data.

If it were SQL I would just do a

select into <table> where <id> between 1-5000

etc...until I was done.

Access isn't working with me here.

Help....please....🙂

 

[Haircut]

Shouldn't the statement be:

select * into <to table>
from <from table>
where <id> between 1 and 5000

 

[bunker]

Yes it should 😛.

I just said screw it and imported it into SQL, split it up, then exported back to Access.

I still hate access!