Microsoft Access Help.....please :)

bunker

Lifer
Apr 23, 2001
10,578
0
71
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

Platinum Member
Apr 23, 2000
2,248
0
0
Shouldn't the statement be:

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

bunker

Lifer
Apr 23, 2001
10,578
0
71
Yes it should :p.

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

I still hate access!