View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams[_2_] Tim Williams[_2_] is offline
external usenet poster
 
Posts: 298
Default Importing Text File problem

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