Size of an Excel database

[nfpk]

Is the limit of posts in Excel the maximum rows? 65536 (minus one for fieldnames?

Can you continue the database on the next sheet, and the next, and the next.......????
So that you get 256 * 65535 posts????

nfpk

 

[carrr]

No, buddy...that's 65,535 (less the column names, of course) per workbook. 256 columns, 65,536 rows. Of course, try packing that much in and you'll likely come up way shorter. i.e. Once Excel's cell memory or heap space get(s) taxed, you're going to get out of memory errors. Of course, you can tweak this (and you can double-up rows within the same sheet, if your column demands allow, but...why push the upper bounds? Use Access if you've got more data than Excel can handle...or something even more robust, if need be.

 

[nfpk]

Ok..... thanks..... I was thinking of that myself...... but who knows.......

 

[KenWright]

You can always use Access to store the data and then query it using Excel, so you still get a nice front end to play with. That allows you to have a database thousands of times greater than Excel's storage capability.

Data / Import External Data / New Database Query

Regards
Ken..........