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

Post a few lines of the text. I can write a macro to fix the returns in the
file. The file uses a MAC return instead of a windows/DOS return.

"Spike" wrote:

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

see below this is all the first row of the text file, the second row starts
with "Silver Hammer" which you will see at the end.

When using the Wizard the text is separated by squares which does not come
out as below; i do not know why.



Name Artist Composer Album Grouping Genre Size Time Disc Number Disc
Count Track Number Track Count Year Date Modified Date Added Bit Rate Sample
Rate Volume Adjustment Kind Equalizer Comments Play Count Last Played Skip
Count Last Skipped My Rating Location Come Together The Beatles Paul
McCartney/John Lennon Abbey Road Pop 4228980 260 1 1 1 17 1969 11/17/07 5:49
AM 11/17/07 2:20 AM 128 44100 AAC audio file MAC
HD:Users:markchilds:Music:iTunes:iTunes Music:The Beatles:Abbey Road:01 Come
Together.m4a Something The Beatles George Harrison Abbey
Road Pop 2991451 183 1 1 2 17 1969 11/17/07 5:49 AM 11/17/07 2:20
AM 128 44100 AAC audio file 1 2/8/08 9:00 AM MAC
HD:Users:markchilds:Music:iTunes:iTunes Music:The Beatles:Abbey Road:02
Something.m4a Maxwell's Silver Hammer The Beatles Paul McCartney/John
Lennon Abbey Road Pop 3404942 207 1 1 3 17 1969 11/17/07 5:49 AM 11/17/07
2:20 AM 128 44100 AAC audio file MAC
HD:Users:markchilds:Music:iTunes:iTunes Music:The Beatles:Abbey Road:03
Maxwell's Silver Hammer.m4a Oh! Darling

--
with kind regards

Spike


"Joel" wrote:

Post a few lines of the text. I can write a macro to fix the returns in the
file. The file uses a MAC return instead of a windows/DOS return.

"Spike" wrote:

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

email me the text file. The posting won't help

joel dot warburg at itt dot com.

It looks like fix width data and I need to get the column location correct.

"Spike" wrote:

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

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

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