Home » RDBMS Server » Server Utilities » flat file --- its urgent
flat file --- its urgent [message #70064] Mon, 08 April 2002 01:46 Go to next message
kim
Messages: 116
Registered: December 2001
Senior Member
hi
i am trying to fetch data from fox pro to oracle, not having worked on fox, i have no idea how to bring data on flat file from fox so that it could be fetched to oracle .
plaease if any one could guied me in simple language.
its urgent
thanks in advance
Re: flat file --- its urgent [message #70065 is a reply to message #70064] Mon, 08 April 2002 02:15 Go to previous messageGo to next message
Sujit Mahapatra
Messages: 19
Registered: March 2002
Junior Member
Make a flat file (SDF Format?): Then u need to have foxpro.
Go to Foxpro and use this table: Do this
USE
COPY TO FLATFILE.TXT TYPE SDF
(You can try also without giving TYPE SDF).

This FLATFILE.TXT is the flat file you wanted.

If you don't have foxpro, then you can use MS Excel:
Open the XLS. Then click on File | Open.

Then in the file type option at the bottom of
the open dialog box, choose database files (*.dbf), then open ur data file.

Cheers,
Sujit
Re: flat file --- its urgent [message #70068 is a reply to message #70064] Mon, 08 April 2002 04:52 Go to previous messageGo to next message
kim
Messages: 116
Registered: December 2001
Senior Member
thanks a lot
sujeet , I will try as you say.
one more thing is this the only way to do fetching?
Re: flat file --- its urgent [message #70070 is a reply to message #70068] Mon, 08 April 2002 06:38 Go to previous message
Sujit Mahapatra
Messages: 19
Registered: March 2002
Junior Member
Hi Kim,
There are other ways, it is long since I have worked
on FoxPro. But I believe there are more complex ways.

Do you have any concern over the method I have told?
Don't have any reserves. Tell me if u face any trouble.
There is always a way out.

Cheers,
Sujit
Previous Topic: a simple question about sqlload
Next Topic: Datafiles
Goto Forum:
  


Current Time: Fri Dec 02 17:14:11 CST 2022