+ Reply to Thread
Results 1 to 2 of 2

Saving worksheet as a CSV (comma delimited) doesnt work. Ideas?

  1. #1
    Registered User
    Join Date
    05-07-2006
    Posts
    15

    Question Saving worksheet as a CSV (comma delimited) doesnt work. Ideas?

    I'm trying to save a spreadsheet into a CSV (described in the title), and when I open it, it appears to have the look as a workbook icon.
    Now, if I rename the file extension to .txt, then it places the , in the fields as seperators so it can be uploaded to my database. I have tried saving the worksheet to every file type using the "save as " option, and nothing gives me the look of a .txt when I go to open it.
    Is there something wrong with my excel 2007. I had that option in 2003 and it worked just fine.

    Thanks for any suggestions.

    I have already tried uninstalling and reinstalling the program to no avail.

    -Trace

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075
    The icon next to the file in the file list indicates the default program. In this case it sounds as though csv files are automatically opening in Excel. This doesn't mean it isn't a csv file. Try opening the csv file in Wordpad or a similar text editor. You may find it's really okay.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1