See Chip Pearson's site for sample code. Specify space as a delimiter:

http://www.cpearson.com/excel/imptext.htm import/export text files

--
Regards,
Tom Ogilvy


"Nuc" wrote in message
...

What about using an open statement such as:

'Open "file.dat" For Input As #1 'Open file for input to worksheet
'For i = 1 To ??
'Line Input #1, commandline
'Worksheets("Sheet2").Cells(i, 1) = commandline

I don't really know how to go from here.. This is only inputing the
file into one column and I need two or more columns.

Using the record macro like you said is ok but this would seem to work
so that I can define the starting and stopping point at where I need to
take the data. Such as taking lines 13 to 100 from the .dat file and
importing them to the worksheet.

Thanks,

Nuc


--
Nuc
------------------------------------------------------------------------
Nuc's Profile:
http://www.excelforum.com/member.php...o&userid=28572
View this thread: http://www.excelforum.com/showthread...hreadid=482329