Results 1 to 2 of 2

Thread: CSV Problem

  1. #1
    Join Date
    Aug 2004
    Posts
    14

    Unanswered: CSV Problem

    Here is my problem...

    I have a external organization that only takes files in a CSV format for uploading. I receive the data that is needed for the CSV file in Excel. But, before I can send it to the organization for uploading (in CSV format), I have to convert some of the columns to different formats...which the CSV will not save when I try to convert the Excel document to the CSV format.

    Does anyone know, or have any suggestions, about how I can save specific formats (like custom number/text formats) when converting from an Excel file to a CSV file?

    Thanks
    Chaci

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    my simple advice is dont bother, if the data is going externally and i presume to for loading into a database then all the formatting will be lost anyway as the db package that this external company uses will define its own formating for reporting,
    for clarification, you dont hold formatted data in db tables

Posting Permissions

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