K
KH
Are there any maximum line capacity constraints when downloading a
data file into Excel 2000?
data file into Excel 2000?
K
keepitcool
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 >
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 >