Importing Text File problem

S

Spike

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.
 
J

Joel

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.
 
S

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
 
J

Joel

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.
 
J

Joel

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 said:
Try just opening the file and setting "File origin" to "Macintosh"

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top