Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    .csv files (excel2000)

    I have a co-worker who has to send a comma-delimited file to an ftp site daily. Today, she walked in to find her old computer replaced with a new one. This is not a computer savvy person and the deletion of her numerous desktop shortcuts has just sent the poor woman over the edge. Anyway, last time she had trouble with this, I figured out that somehow she had saved all her headings into the same field but had all her data in separate fields. But this time, I can't figure it out. I even went back and opened one of her old delimited files and converted it back to excel and I can't even save that in .csv format. I get that error that some data may be lost. I click yes to save it anyway and take the chance of losing data but it simply saves as an excel file again. Can anyone help me out here. Other than not being computer savvy, this woman is an excellent employee and I hate to see her over the edge (and our IT guys are so overwhelmed right now they laughed when I asked them the question and said to go away). Can you tell we're in the middle of a horrid upgrade?

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

    Re: .csv files (excel2000)

    If you save an Excel workbook as some kind of text file (such as CSV), Excel routinely mutters that some data may not be compatible with the CSV format. Reply Yes to the question if you want to save it anyway. The caption should show that it now is a CSV file. When you close it, Excel asks if you want to save the file even though you didn't change anything. This time, answer No.

  3. #3
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: .csv files (excel2000)

    I have tried that several times with this sample file. And it still looks like an excel file except it has a small a below the x in the icon. And when I open it, it opens as an excel file. Am I doing something wrong in the process of saving it. I go to File..... Save As........I change the Save As Type to comma-delimited by selecting it from the drop down menu. I get that message about losing changes and answer yes. Then I close excel and click no this time. What is on my desktop still looks like an excel file and has no extension on the end of the file.

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

    Re: .csv files (excel2000)

    When you install Office, .CSV files are associated with Excel, so they get an Excel-like icon and open in Excel if you double click them. But if you open an .CSV file in a text editor such as Notepad, you will see that it really is a text file.

    Start Windows Explorer and select Tools | Folder Options... Activate the View tab and clear the check box labeled "Hide extensions for known file types". Click OK. You should now see the extension.

  5. #5
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: .csv files (excel2000)

    Thanks, Hans. Once again you have made the light bulb glow above my head and the halo around yours. <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23>

Posting Permissions

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