Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Convert dbf file to ASCII (text) file
This is a discussion on Convert dbf file to ASCII (text) file within the Oracle forums, part of the Databases category; 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 ...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
02-17-2008
|
|||
|
|||
|
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 
|
| Sponsored Links |
|
02-17-2008
|
|||
|
|||
|
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.
|
|
02-17-2008
|
|||
|
|||
|
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;
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can we connect to a text file using C/C++? | Seedrick | C and C++ | 4 | 03-12-2008 09:15 AM |
| How to create ASCII file in oracle with out using UTL package | srinivasa.dinesh | Oracle | 2 | 02-05-2008 05:31 AM |
| Upload text file | Geek_Guest | ASP.NET | 0 | 11-07-2007 07:12 PM |
| transcribing .rec file to text file | Mamal | Scripting | 1 | 08-17-2007 10:57 AM |
| convert .class file to .exe file | Geek_Guest | Java | 3 | 07-02-2007 10:42 AM |
All times are GMT -4. The time now is 03:40 PM.
