Please help ... urgent...Access table split..

[bengalliboy]

I need some code to split a big table in Access. I am using ODBC to export data from Access... it works fine for a small records but when the table get bigger it hangs. I want to split the my table and am using VBA and I can see my big table... I just want to break the table in equal or close to equal small tables that will contain rrecs...

So the big table got 100K, I want 4 different table w each 25K ... TIA

 

[pranay7777]

create four tables 1,2,3,4 write code which copies data from ur table to table1 till u reach a counter 1/4 of ur table size....and then fill table 2 and then 3 and then 4...