how to make a table with 10 million rows in one column? [General]

Prev: Additional Information
Next: Pie chart in columnar report

From: pemt on 23 Mar 2010 09:54

Jeff,

Thanks.
Actually I have more than 10 M records to fill with and each one is unique.

pemt

"Jeff Boyce" wrote:

> ?Simple or harder?
>
> Simple: Open Excel. Start numbering (down) 1 (down) 2 (down) 3. Highlight
> these and extend as far as you can go.
> Copy that into Access.
> Repeat, starting at next number, until you reach 10M.
>
> Harder: Create a procedure in Access that inserts a record/number, adds
> one, inserts (another), repeats until 10M.
>
> Now, why? What will having a table with 10M rows numbered 1 - 10,000,000
> allow you to do?
>
> (I ask because there may be a MUCH simpler way to accomplish what you want,
> if we only knew what that was...)
>
> Good luck!
>
> Regards
>
> Jeff Boyce
> Microsoft Access MVP
>
> --
> Disclaimer: This author may have received products and services mentioned
> in this post. Mention and/or description of a product or service herein
> does not constitute endorsement thereof.
>
> Any code or pseudocode included in this post is offered "as is", with no
> guarantee as to suitability.
>
> You can thank the FTC of the USA for making this disclaimer
> possible/necessary.
>
>
> "pemt" <pemt(a)discussions.microsoft.com> wrote in message
> news:C8BB251F-1845-4148-8E4A-DFC344AC971A(a)microsoft.com...
> > how to make a table with 10 million rows in one column?
> >
> > Num
> > 1
> > 2
> > 3
> > .
> > .
> > .
> > 10,000,000
> >
> > thanks,
> >
> > pemt
>
>
> .
>

From: pemt on 23 Mar 2010 10:05

From: John W. Vinson on 23 Mar 2010 11:45

On Tue, 23 Mar 2010 06:53:01 -0700, pemt <pemt(a)discussions.microsoft.com>
wrote:

>actually I have more than 10 M records to fill with and each one is unique.

THEN STOP!!!!!

It is not necessary to create ten million empty records and then fill them in.

Simply use an Autonumber ID. Add the records as the data becomes available -
importing, appending, entering with a form. Create the record *when there is a
record to create* - not before.
--

John W. Vinson [MVP]

From: John W. Vinson on 23 Mar 2010 11:45

On Tue, 23 Mar 2010 06:48:01 -0700, pemt <pemt(a)discussions.microsoft.com>
wrote:

>John,
>
>Thanks.
>How to run below code in Access to make table?
>n=1
>n=n+1
>n<10000000
>print n /
>end

You *really really don't want to do that*.

See my other reply.

--

John W. Vinson [MVP]

From: pemt on 23 Mar 2010 13:03

Thanks a lot!

"John W. Vinson" wrote:

> On Tue, 23 Mar 2010 06:53:01 -0700, pemt <pemt(a)discussions.microsoft.com>
> wrote:
>
> >actually I have more than 10 M records to fill with and each one is unique.
>
> THEN STOP!!!!!
>
> It is not necessary to create ten million empty records and then fill them in.
>
> Simply use an Autonumber ID. Add the records as the data becomes available -
> importing, appending, entering with a form. Create the record *when there is a
> record to create* - not before.
> --
>
> John W. Vinson [MVP]
> .
>

First | Prev | Next | Last
Pages: 1 2 3 4 5
Prev: Additional Information
Next: Pie chart in columnar report