Need to split table

[lisaharris]

I have a table with 110k records (just two fields) that I need to split into 5 more manageable pieces. Is there an automated way to do that?

__________
It's better to have loved and lost than live with the idiot for the rest of your life.

 

[Remou]

How about a make table query?

 

[JoeAtWork]

110K isn't really that many records. Personally, I don't like the idea of splitting up a table (unnormalized) for this reason. Perhaps you can accomplish your goal by adding indexes, or using queries that filter records (so instead of using 1 of the 5 tables, you simply create a query that filters on the same parameters as you would use to split up the table).

 

[lisaharris]

It does need to be split - I'm using Access to clean up this table, and another product to run a matched import (using an api). The problem is that the other product chokes on more than 30k records at a time.

I'm doing the make-table query suggestion. I added another column and assigned each record a 1,2,3 or 4 identifier, then I'll run make-table queries for each identifier.

Just had to think it through.... Thanks!

__________
It's better to have loved and lost than live with the idiot for the rest of your life.

 

[MichaelRed]

hmmmmmmmmmmmmmmm ... mmmmmmmmmmmmm

Good luck with a 'product' which chokes on 30K records ... doesn't sound much like a robust approach ...




MichaelRed

 

[ProgramError]

Pssst...

My Access front end is 33k alone...
Back end has in excess of 3,000 records

I wouldn't want to use it with your 'other product' either.

Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.