| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
more than 65536 rows
Hi,
I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more than 65536 rows
Christopher,
Excel 2007 has a million rows. -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Christopher Naveen" wrote in message ... Hi, I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more than 65536 rows
Or a different application--like Access????
Christopher Naveen wrote: Hi, I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more than 65536 rows
Just out of curoisity, how many rows are available in Access?
"Dave Peterson" wrote in message ... Or a different application--like Access???? Christopher Naveen wrote: Hi, I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more than 65536 rows
I'm not an Access user, but from what I've read, it's unlimited (well, limited
by physical space on the drive that holds the database). Zone wrote: Just out of curoisity, how many rows are available in Access? "Dave Peterson" wrote in message ... Or a different application--like Access???? Christopher Naveen wrote: Hi, I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more than 65536 rows
See Help, Specifications, in 2003, 2 GB for the table so it will depend
on the record contents. Zone wrote: Just out of curoisity, how many rows are available in Access? "Dave Peterson" wrote in message ... Or a different application--like Access???? Christopher Naveen wrote: Hi, I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more than 65536 rows
Is it 2GB for a table or for the enitre MDB file? I've noticed that Access
2000 can be unstable with MDB files that are over 2GB. "Bob I" wrote in message ... See Help, Specifications, in 2003, 2 GB for the table so it will depend on the record contents. Zone wrote: Just out of curoisity, how many rows are available in Access? "Dave Peterson" wrote in message ... Or a different application--like Access???? Christopher Naveen wrote: Hi, I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more than 65536 rows
2003 states 2GB for both. So you could be limited to a single table if
it is big enough. Pete Stavrakoglou wrote: Is it 2GB for a table or for the enitre MDB file? I've noticed that Access 2000 can be unstable with MDB files that are over 2GB. "Bob I" wrote in message ... See Help, Specifications, in 2003, 2 GB for the table so it will depend on the record contents. Zone wrote: Just out of curoisity, how many rows are available in Access? "Dave Peterson" wrote in message ... Or a different application--like Access???? Christopher Naveen wrote: Hi, I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more than 65536 rows
MS documents Access 2007's specifications and limits he
http://office.microsoft.com/en-us/ac...CH100621861033 Zone wrote: Just out of curoisity, how many rows are available in Access? "Dave Peterson" wrote in message ... Or a different application--like Access???? Christopher Naveen wrote: Hi, I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. -- Dave Peterson -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more than 65536 rows
Thanks, that what i thought and have always used the 2GB limit for my Access
files. If able to, I could go much larger than 2GB but I resort instead to linking tables between MDB files. "Bob I" wrote in message ... 2003 states 2GB for both. So you could be limited to a single table if it is big enough. Pete Stavrakoglou wrote: Is it 2GB for a table or for the enitre MDB file? I've noticed that Access 2000 can be unstable with MDB files that are over 2GB. "Bob I" wrote in message ... See Help, Specifications, in 2003, 2 GB for the table so it will depend on the record contents. Zone wrote: Just out of curoisity, how many rows are available in Access? "Dave Peterson" wrote in message ... Or a different application--like Access???? Christopher Naveen wrote: Hi, I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more than 65536 rows
Hi Dave,
Thanks for this link. Do you know what it means - "Number of Actions in a Macro - 999"? Pete On Sep 20, 8:33 pm, Dave Peterson wrote: MS documents Access 2007's specifications and limits hehttp://office.microsoft.com/en-us/ac....aspx?pid=CH10... Zone wrote: Just out of curoisity, how many rows are available in Access? "Dave Peterson" wrote in message ... Or a different application--like Access???? Christopher Naveen wrote: Hi, I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more than 65536 rows
No idea at all.
Pete_UK wrote: Hi Dave, Thanks for this link. Do you know what it means - "Number of Actions in a Macro - 999"? Pete On Sep 20, 8:33 pm, Dave Peterson wrote: MS documents Access 2007's specifications and limits hehttp://office.microsoft.com/en-us/ac....aspx?pid=CH10... Zone wrote: Just out of curoisity, how many rows are available in Access? "Dave Peterson" wrote in message ... Or a different application--like Access???? Christopher Naveen wrote: Hi, I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - -- Dave Peterson |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more than 65536 rows
Pete,
Access has macros, and it has VBA; they're not the same. The macros are old-style lists of canned actions (open a query, form, etc.), and that's where the 999 limit is. -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Pete_UK" wrote in message ups.com... Hi Dave, Thanks for this link. Do you know what it means - "Number of Actions in a Macro - 999"? Pete On Sep 20, 8:33 pm, Dave Peterson wrote: MS documents Access 2007's specifications and limits hehttp://office.microsoft.com/en-us/ac....aspx?pid=CH10... Zone wrote: Just out of curoisity, how many rows are available in Access? "Dave Peterson" wrote in message ... Or a different application--like Access???? Christopher Naveen wrote: Hi, I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more than 65536 rows
Thanks Earl.
Pete On Sep 21, 4:19 pm, "Earl Kiosterud" wrote: Pete, Access has macros, and it has VBA; they're not the same. The macros are old-style lists of canned actions (open a query, form, etc.), and that's where the 999 limit is. -- Regards from Virginia Beach, Earl Kiosterudwww.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... -----------------------------------------------------------------------"Pete_UK" wrote in message ups.com... Hi Dave, Thanks for this link. Do you know what it means - "Number of Actions in a Macro - 999"? Pete On Sep 20, 8:33 pm, Dave Peterson wrote: MS documents Access 2007's specifications and limits hehttp://office.microsoft.com/en-us/ac....aspx?pid=CH10... Zone wrote: Just out of curoisity, how many rows are available in Access? "Dave Peterson" wrote in message ... Or a different application--like Access???? Christopher Naveen wrote: Hi, I have a database which contains morethan 65536 rows. Pls tell me how to open the database and pls tell me which application helps me to open more than 65536 rows. -Christ. -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel should have more than 65536 rows, it should go 150000 | Excel Discussion (Misc queries) | |||
| How to put in over 65536 rows? | Excel Discussion (Misc queries) | |||
| Add more than 65536 rows? | Excel Worksheet Functions | |||
| Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95? | Excel Discussion (Misc queries) | |||
| Can I increase row capacity beyond 65536 rows | Excel Worksheet Functions | |||
![Christopher Naveen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
