For all excel versions:
a sheet has a maximum of
2^16 = 65536 rows
2^8 = 256 columns

the rest is up to installed memory.


if you have more rows and need to query =

if it's an exported data dump from another package that doesn't support
database formats i suggest querying the generated textfile with data/query
else any database format would be preferred.

Note that Excel doesn't need MS-Access to handle .mdb files.
(But a recent version of the JET engine is advisable)
Using standard SQL commands, u CAN even drop /create tables and indexes

Highly recommended/ (virtually a MustRead :) =
www.erlandsendata.no = Ado/DAO sections.


You may query a database server, or a mdb or text file of "unlimited"
length, as long as the retrieved recordset is no longer then the maximum
dimensions listed above.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


(KH) wrote:

Are there any maximum line capacity constraints when downloading a
data file into Excel 2000?