What If a Table has a Million Rows?!
 

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

What If a Table has a Million Rows?!
 

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" 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

What If a Table has a Million Rows?!
 

On Dec 10, 9:50*am, "Cimjet" 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" 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 about
Excel 2010?

Thanks

What If a Table has a Million Rows?!
 

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/ex...73849.aspxFrom that link, you may find the information for 2010.RegardsJohn"Mike" wrote in message Dec 10, 9:50 am, "Cimjet" 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" 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

What If a Table has a Million Rows?!
 

Hi again
Try this one
http://office.microsoft.com/en-us/ex...010073849.aspx
Hope this one works
John
"Cimjet" wrote in message
...
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/ex...73849.aspxFrom
that link, you may find the information for 2010.RegardsJohn"Mike"
wrote in message
Dec
10, 9:50 am, "Cimjet" 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" 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

What If a Table has a Million Rows?!
 

I found the information for 2010
http://office.microsoft.com/en-us/ex...in=HP005199291

Hope this one works.
John
"Mike" wrote in message
...
On Dec 10, 9:50 am, "Cimjet" 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" 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 about
Excel 2010?

Thanks

What If a Table has a Million Rows?!
 

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

What If a Table has a Million Rows?!
 

On Fri, 10 Dec 2010 12:06:25 -0800 (PST), DCG-jaeson
wrote:

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


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

16 worksheets per 1 million rows.

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

http://www.hometheaterinfo.com/dvdlist.htm

What If a Table has a Million Rows?!
 

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

What If a Table has a Million Rows?!
 

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

What If a Table has a Million Rows?!
 

On Mon, 13 Dec 2010 16:58:12 -0800 (PST), Greg Glynn
wrote:

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


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.

What If a Table has a Million Rows?!
 

2^20

"Mike" wrote in message
...
On Dec 10, 9:50 am, "Cimjet" 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" 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 about
Excel 2010?

Thanks

What If a Table has a Million Rows?!
 

On Mon, 13 Dec 2010 21:48:42 -0800, "Bill Oertell"
wrote:

2^20

"Mike" wrote in message
...
On Dec 10, 9:50 am, "Cimjet" 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" 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 about
Excel 2010?

Thanks


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