What If a Table has a Million Rows?!

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi Everyone,

You know Excel has a limited capacity on the number of rows, around
65000

Does it mean Excel can't handle bigger data files? What if a table or
datafile has a million or so rows?

Is there a way to go around this?

Thanks,
Mike
 
Hi Mike
You will need to upgrade to XL2007.
2007 has over a million rows and 16384 columns per sheet.
You can't increase the amount of rows or column in XL2003 or older.
HTH
John
 
Hi Mike
You will need to upgrade to XL2007.
2007 has over a million rows and 16384 columns per sheet.
You can't increase the amount of rows or column in XL2003 or older.
HTH
John










- Show quoted text -
Click to expand...

You know exactly how many rows in Excel 2007 is the limit? How about
Excel 2010?

Thanks
 
Hi Mike
This is a link to XL07, I don't know exactly the specification for 2010 but for
rows and columns,
It should be the same, not less.
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspxFrom that link, you may find the information for 2010.RegardsJohn"Mike" <[email protected]> wrote in message Dec 10, 9:50 am, "Cimjet" <[email protected]> wrote:> Hi Mike> You will need to upgrade to XL2007.> 2007 has over a million rows and 16384 columns per sheet.> You can't increase the amount of rows or column in XL2003 or older.> HTH> John>> "Mike" <[email protected]> wrote in message>> > Hi Everyone,>> > You know Excel has a limited capacity on the number of rows, around> > 65000>> > Does it mean Excel can't handle bigger data files? What if a table or> > datafile has a million or so rows?>> > Is there a way to go around this?>> > Thanks,> > Mike- Hide quoted text ->> - Show quoted text -You know exactly how many rows in Excel 2007 is the limit? How aboutExcel 2010?Thanks
 
Hi Mike,

You have a enormous database huh?! LOL! If Excel 2010 or maybe
Excel2000 only can't hold your Database, I suggest you to break it and
use another Worksheets, then make a summary.

Hope this idea will help!
~jaeson
 
Hi Mike,

You have a enormous database huh?! LOL! If Excel 2010 or maybe
Excel2000 only can't hold your Database, I suggest you to break it and
use another Worksheets, then make a summary.

Hope this idea will help!
~jaeson
Click to expand...


Let's see... 1 million lines divided by 65,535...

16 worksheets per 1 million rows.

A good example can be DL'd here: (A 2k3 DVD database)(ALL of them).

http://www.hometheaterinfo.com/dvdlist.htm
 
Why not store it in Access and query it from Excel using ADO?


HTH

Bob

"Mike" wrote in message

Hi Everyone,

You know Excel has a limited capacity on the number of rows, around
65000

Does it mean Excel can't handle bigger data files? What if a table or
datafile has a million or so rows?

Is there a way to go around this?

Thanks,
Mike
 
Bob's right. If you've got a million rows of data, you don't need a
spreadsheet, you need a database.
 
Bob's right. If you've got a million rows of data, you don't need a
spreadsheet, you need a database.
Click to expand...


Access is slow as a dog on my 48MB mere 170k row DVD database IN EXCEL.

Excel is an order of magnitude faster on apparently ANY flat file
database.

No need to break it up into tables either since the data is ALL fixed
unless a disc is discontinued. Whoopie doo.

Access is either a dog in such a case, or there was some lame, hidden
optimizer for it I had yet to 'run'.

ANY lookup in excel on it was as snappy as lightning.

Not so with ANY lookup from within Access.
 
2^20

Hi Mike
You will need to upgrade to XL2007.
2007 has over a million rows and 16384 columns per sheet.
You can't increase the amount of rows or column in XL2003 or older.
HTH
John










- Show quoted text -
Click to expand...

You know exactly how many rows in Excel 2007 is the limit? How about
Excel 2010?

Thanks
 
2^20



You know exactly how many rows in Excel 2007 is the limit? How about
Excel 2010?

Thanks
Click to expand...

Go back and read the thread. It has already been stated (linked to).
 
Back
Top