Re: [MS_AccessPros] Re: Split Access table

Thanks Bill for your response!

Yes I import the data from a text file to this table and then adds few calculated fields and then this output needs to be uploaded to a web tool which accept .XLS format with only 10000 records.

That's why I need to split the result.

Cheers
TL

Sent from BlackBerry® on Airtel

-----Original Message-----
From: Bill Mosca <wrmosca@comcast.net>
Date: Sun, 18 Aug 2013 15:11:32
To: <MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Re: Split Access table

 



Tech

I see no need to split the table. If you properly index the table you should be fine. In fact, splitting would only complicate things. Every query would have to do a union on the 2 tables and that would just slow up the processing.

What is the purpose of this table? are you using it to import data from another source?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E

--- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> , "Tech Learner " <tech_learner@...> wrote:
>
> 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/