Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to increase my column length to enter 600,000 entries
i am using a excel office version and connecting it to data loggin system. i
will need to log data for 600,000 entries in a single file continously. I would like to know if these many entries are posible or if not then how can i go about it to make it possible |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to increase my column length to enter 600,000 entries
Excel is limited to 65,536 rows Maximum. So you cannot read in a continuous
file more than this. It is possible to split into multiple columns, so that when the first column(s) are filled you select the top of the next and so on, or use another worksheet(s) to store the subsequent rows. But generally more than 65,536 rows makes for data management over head, but it does depend what you wish to do with the data once it is loaded. -- Cheers Nigel "jeffrey" wrote in message ... i am using a excel office version and connecting it to data loggin system. i will need to log data for 600,000 entries in a single file continously. I would like to know if these many entries are posible or if not then how can i go about it to make it possible |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to increase my column length to enter 600,000 entries
log the data in a text file, DBASE file XML or MDB. (last is fastest) then use QueryTable or ADO to work on a subset (with a max of 65536 rows) -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam jeffrey wrote : i am using a excel office version and connecting it to data loggin system. i will need to log data for 600,000 entries in a single file continously. I would like to know if these many entries are posible or if not then how can i go about it to make it possible |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I increase the length of a drop down list? | Excel Worksheet Functions | |||
Can I increase the length data from a formula in a cell? | Excel Discussion (Misc queries) | |||
Can I increase the length data from a formula in a cell? | Excel Worksheet Functions | |||
How do I increase the length of file names? | Excel Discussion (Misc queries) | |||
Increase Length of Name Box | Excel Discussion (Misc queries) |