| flat file --- its urgent [message #70064] |
Mon, 08 April 2002 01:46  |
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  |
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 #70070 is a reply to message #70068] |
Mon, 08 April 2002 06:38 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
