How to split large Access table into 2 smaller tables
Posted on 2013-11-25
I have a very large table in Access 2010 that I want to split into 2 smaller tables. I don't care which records end up in each file. I know some SQL and some VBA but I wouldn't consider myself an expert with either.
I'm having 2 issues right now:
1. what's the fastest way to get an accurate record count? I know I can open the table and go to the last record but that's taking forever and Access seems to hang when I do that ....
2. once I know how many records I have, is there a way to do a Make Table query based on record count (i.e. put the first X number of records in Table1 and the rest in Table2?
Also open to any other suggestions you may have to help me get this done.
Many thanks, in advance, for your help!