how to make a table with 10 million rows in one column?
in [General]
|
From: pemt on 22 Mar 2010 12:44 how to make a table with 10 million rows in one column? Num 1 2 3 .. .. .. 10,000,000 thanks, pemt
From: KARL DEWEY on 22 Mar 2010 13:03 WHY! -- Build a little, test a little. "pemt" wrote: > how to make a table with 10 million rows in one column? > > Num > 1 > 2 > 3 > . > . > . > 10,000,000 > > thanks, > > pemt
From: John W. Vinson on 22 Mar 2010 13:04 On Mon, 22 Mar 2010 09:44:01 -0700, pemt <pemt(a)discussions.microsoft.com> wrote: >how to make a table with 10 million rows in one column? > >Num >1 >2 >3 >. >. >. >10,000,000 > >thanks, > >pemt Start with a table NUM with 1000 rows, with one field N, values 0 through 999. You can use Excel... Insert... Fill Series to create it quickly, and copy and paste into a table. Then create a Cartesian join query INSERT INTO bigtable(Num) SELECT 1 + N1 + 1000 * N2 + 1000000 * N3 FROM Num AS N1, Num AS N2, Num AS N3 WHERE N3 < 10; Lots of other ways to do it but this should be quick and easy. Compact the database when you're done... -- John W. Vinson [MVP]
From: Jeff Boyce on 22 Mar 2010 13:04 ?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: Douglas J. Steele on 22 Mar 2010 14:17
Just a note that you can only do the simple approach if you're using Excel 2007 (or newer) -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Jeff Boyce" <nonsense(a)nonsense.com> wrote in message news:%23KRKJHeyKHA.4752(a)TK2MSFTNGP04.phx.gbl... > ?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 > > |