Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximim download file size into Excel 2000
Are there any maximum line capacity constraints when downloading a
data file into Excel 2000? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximim download file size into Excel 2000
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open 2000 file attachments in Excel 2000 | Excel Discussion (Misc queries) | |||
A download of Analysis ToolPak (Analys32.xll) for Excel 2000 | Excel Worksheet Functions | |||
How do I download and open a CSV file in Excel 2000? | Setting up and Configuration of Excel | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Where can I download the "solver" add-in for Excel 2000? | Excel Discussion (Misc queries) |