csv files

Results 1 to 2 of 2

Thread: csv files

  1. #1
    anagha Guest

    Default csv files

    I need to write the results of a query to a .csv file. The data that is written to the file has to have double quotes as text qualifiers and commas as the delimiters. This file will be opened by the users from excel.<BR><BR>I am encountering one problem. When I try to open the file in excel, some data of character data type( like for eg. the employee ID of type "01111"), opens up as "1111". I want excel to treat the "01111" as "01111". <BR><BR>Any help in solving this problem is appreciated.

  2. #2
    E! Guest

    Default RE: csv files

    One suggest would be to create an Excel template that gets loaded from the csv file... then, where the fields are getting truncated, format those sells to be text... That may work out...

Posting Permissions

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