The file was a tab delimited file, but there were no end of line characters.
Somehow the end of line got dropped when importing the file from the IPOD.

"Tim Williams" wrote:

Try just opening the file and setting "File origin" to "Macintosh"

Tim

"Spike" wrote in message
...
i have been passed a text file which i believe has come from an ipod and is
a
list of all the music on the ipod. It is quite large 2,728 Kb. When i
try
to import it into Excel using the Import Text File Wizard it will only
fill
the top row (in both 2003 and 2007). I cannot get it to use row 3, 4 and
so
on.

I have tried using ADO without success.

The data is separated by little squares which is only seen in the Wizard.
If it is opened in NotePad then it neatly comes over in rows.

Any ideas will be greatfully received or do i have to use some Mac
software.
--
with kind regards

Spike