LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 140
Default Importing Text File problem

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
problem in importing text file! via135 Excel Discussion (Misc queries) 2 May 4th 07 06:37 AM
Importing text file, only option to edit existing file smokey99 Excel Discussion (Misc queries) 8 April 26th 06 09:08 PM
importing a text file - problem with dates "Americanising" strippier Excel Discussion (Misc queries) 3 February 21st 06 05:42 PM
importing text file, removing data and outputting new text file Pal Excel Programming 8 February 27th 04 08:32 PM
Problem importing a txt file Jerry[_17_] Excel Programming 3 February 21st 04 02:33 AM


All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"