Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unable to Import text files into Excel (2000)

    On trying to imort a text file into Excel l can get one file to appear , but when l try to import another one it makes the file blank for some odd reason.
    Any ideas what l am doing wrong to cause this.
    I would like to import details of the next text file beneath the first, see screenshot for details.

    Any assistance would be appreciated.

    Justin

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Import text files into Excel (2000)

    When I use the XL2K import wizard, the last thing it asks me is where do you want the data put. Do you get that dialog box? What are you specifying?
    Legare Coleman

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Unable to Import text files into Excel (2000)

    If you use File | Open..., the text file will be opened in a new window, as the menu option implies. If you use Data | Get External Data | Import Text File..., you'll be asked where to put the data after you click Finish, as Legare says.

  4. #4
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Import text files into Excel (2000)

    Thanks for that Hans, it appears to work fine.

    Justin.

  5. #5
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Import text files into Excel (2000)

    Thank you for your help, Hans has resolved this issue for me.

    Regards
    Justin.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •