Splitting a table

[Guest]

I have a table with over 300,000 records!! they are sorted by 'exchange
codes'. I need to split the table so that all entries with the same 'exchange
code' are in it's own table. I know I could do a query with a filter but I
would have to do a manual query for each exchange code -there are thousands
of these! Is there an easier way to split the whole table into lots of
smaller ones??

 

[horn1]

I have a table with over 300,000 records!! they are sorted by 'exchange
codes'. I need to split the table so that all entries with the same
'exchange
code' are in it's own table. I know I could do a query with a filter but I
would have to do a manual query for each exchange code -there are
thousands
of these! Is there an easier way to split the whole table into lots of
smaller ones??

why do you want to split this table?

 

[Van T. Dinh]

It sounds to me that you should keep them in one Table.

You can create ONE Parameter Query with the 'exchange code' as the Parameter
so when the Query is executed, Access will ask for the 'exchange code'
required.

Also, if you regularly select by 'exchange code', create an Index on this
Field.

Check Access Help / your Access books on Parameter Queries.