Results 1 to 3 of 3

Thread: Convert dbf file to ASCII (text) file

  1. #1
    Junior Member
    Join Date
    Feb 2008
    Answers
    1

    Convert dbf file to ASCII (text) file

    I want to convert the DBF File (which is generated using FoxPro) into the ascii (like text file (properly delimited by commas) and vice versa in oracle. Is there any use of java in this method. Plz reply me because its urgent.

    Thanks in advance,
    Mohit Sharma


  2. #2
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Convert dbf file to ASCII (text) file

    I do not know how to convert DBF to ASCII Directly. But in the following way we may convert DBF to excel , then excel to ASCII format. To convert DBF to excel use the following command.

    Export to filename Type XLS.
    Then open the file in excel. Select save as type you want.


  3. #3
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Convert dbf file to ASCII (text) file

    To covert oracle data to ascii format use the following syntax

    SPOOL XXX.TXT
    SELECT FIELD1||','|| FIELD2||','||FIELD3 FROM TABLENAME;
    SPOOL OFF;


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact