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

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

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