OraFAQ Forum: Server Utilities » convert .txt to .dbf and vice versa

Home » RDBMS Server » Server Utilities » convert .txt to .dbf and vice versa

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

convert .txt to .dbf and vice versa [message #299666]

Tue, 12 February 2008 22:36

jayshree.gaur
Messages: 2
Registered: February 2008
Location: faridabad

Junior Member

hi !
can anybody tell me proper code to convert .dbf file to ascii and then to oracle data
or vice -versa

--is there is any direct way to convert a .dbf file to oracle data w/o using any 3rd party tools or software.

this requst is most urgent ,plz tell me the solution as soon as possibe

thanks

Report message to a moderator

Re: convert .dbf file to ascii and then to oracle data [message #299672 is a reply to message #299666]

Tue, 12 February 2008 23:11

Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA

Senior Member

If by .dbf you mean DBASE, then here is one method to convert DBASE tables to Oracle tables:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:711825134415

There are various methods here for converting Oracle tables to text files:

http://asktom.oracle.com/tkyte/flat/index.html

Just about any program can load and unload text files. In Oracle, you can use SQL*Loader or external tables to load them. In DBASE, you should be able to find some copy or list commands to dump them to text files. Various XBASE programs, such as FoxPro can also read .dbf files. So, you can export them from there also. You may also be able to connect from one to the other using ODBC or use migration. So, there are lots of options to choose from.

Report message to a moderator

WANT TO CONVERT .txt file to .dbf file without using any third party tool or software(foxpro) (merge [message #299735 is a reply to message #299666]

Wed, 13 February 2008 01:09

jayshree.gaur
Messages: 2
Registered: February 2008
Location: faridabad

Junior Member

WANT TO CONVERT .txt file to .dbf file without using any third party tool or software(foxpro)
and vice-versa

this is urgent .please reply soon
thanks

Report message to a moderator

Re: WANT TO CONVERT .txt file to .dbf file without using any third party tool or software(foxpro) [message #299756 is a reply to message #299735]

Wed, 13 February 2008 02:17

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

How is this related to Oracle Applications?

By
Vamsi

Report message to a moderator

Re: WANT TO CONVERT .txt file to .dbf file without using any third party tool or software(foxpro) [message #299759 is a reply to message #299735]

Wed, 13 February 2008 02:22

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Is this an Oracle question.
If not, you choose the wrong forum.

Regards
Michel

Report message to a moderator

Re: WANT TO CONVERT .txt file to .dbf file without using any third party tool or software(foxpro) [message #299800 is a reply to message #299735]

Wed, 13 February 2008 04:20

susantaindia
Messages: 12
Registered: January 2008
Location: India

Junior Member

Hi,

First create a .DBF file as the same stracture of the text file.
Open the .DBF file in Foxpro then apply the command "appe from
<your text file name> SDF"

For vice-versa : Copy to <your text file name> SDF

Regards

[Updated on: Wed, 13 February 2008 04:21]

Report message to a moderator

Re: WANT TO CONVERT .txt file to .dbf file without using any third party tool or software(foxpro) [message #299815 is a reply to message #299735]

Wed, 13 February 2008 05:17

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't multipost.
Don't use "urgent".
Post only Oracle questions.
Read OraFAQ Forum Guide.

Regards
Michel

Report message to a moderator

Previous Topic:	Error while using IMP
Next Topic:	IMP-00018: partial import of previous table completed: 491505 rows imported

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 22:47:10 CST 2024