Importing Text Files

[Tony]

I need to import the info from *.txt files produced by a data logger.
There are always 15 columns each holding an integer ranging from 1 to 80 but
the number of rows is usually well above the 65536 worksheet limit.
The help feature tells me to import the first 65536 lines and then import
the rest to another worksheet(s) and to stipulate a commencement row.
The problem is that it will not accept a row number above 32767 whereas I
obviously want to start the import at 65536 + 1 and subsequent multiples of
65k

Help appreciated
TIA
Tony

 

[Trevor Shuttleworth]

Tony

you need to define your row count variable as long.

Regards

Trevor

 

[Tony]

Trevor,
Thanks for the quick reply, but how do I do that ?
I have the feeling that we're getting into VBA here but I have no need for
any of that - all I want to do is manually import the data , move it all
into a single worksheet if necessary/possible and then carry out some very
simple calcs on it like the MAX or MIN of each row etc.

Regards
Tony

 

[jaf]

http://www.google.com/groups?hl=en&lr=&c2coff=1&[email protected]

 

[Electra]

Tia,

use >data>import external data>import data>
browse to the file you want to import and seclect open.

follow the steps you generally do at this point.

Then select import into >new worksheet

Then later when you want to update the data go back to your imported
data sheet and use >data>refresh data (at the bottom of menu)

You can also change some the setting regarding how the data refresh
gets done.
use>data>import external data>data range properties.

If the file name is always the same take a check mark out of >prompt
for file name on refresh.