Tech (your name?)
What determines which records are sent? Instead of using the table, write a query for the records you want. It would be much simpler than trying to maintain 2 tables. And if it is just the latest records you could use a SELECT TOP clause in your query with an ORDER BY clause to get the ones you want.
SELECT TOP 10000 *
FROM MyTable
ORDER BY MyDate DESC
Bill
--- In MS_Access_Professionals@yahoogroups.com, "Tech Learner " <tech_learner@...> wrote:
>
> 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@...>
> 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
> >
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar