[MS_AccessPros] Split Access table

Hi All,

I have an access table 'data_all'. This table have more than 200000 records. I need to split this data in tables of having 10000 records. Number of records in the data_all table will keep on increasing MoM.

I wish to know the best way to split this table in access

Many thanks,
TL
Sent from BlackBerry® on Airtel


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/