importing FoxPro dbf files into Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: importing FoxPro dbf files into Oracle

  1. #1
    Join Date
    Feb 2002
    Posts
    54
    Good day!

    How can i import a FoxPro dbf file into Oracle 8.1.7?
    What oracle utilities do i need and what are the steps involved?



    Thanks in advance.


    D
    =======================
    Manifest plainness,
    embrace simplicity,
    reduce selfishness,
    have few desires. LAO TZU
    =======================
    Share on Google+

  2. #2
    Join Date
    Apr 2002
    Posts
    13
    Can u generate a text file from foxpro database ?

    If u can then user SQLLDR utility to port into Oracle.

    Bye
    Share on Google+

  3. #3
    Join Date
    Feb 2002
    Posts
    54
    tnx..

    but is there no other way aside from using sqlldr and a flat file..


    tnx..

    D

    =======================
    Manifest plainness,
    embrace simplicity,
    reduce selfishness,
    have few desires. LAO TZU
    =======================
    Share on Google+

  4. #4
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    If you have MS Access you can quite easily open/import FoxPro tables and then export them via ODBC to Oracle.
    Access doesn't care about caps so be prepared to create all Oracle tables with caps otherwise it's hard to find them.
    Ales

    Share on Google+

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Hi dear,

    I run my MS-Access2003 and try to open a .dbf file from dos foxpro
    but it can not recognize it any help pls


    Thanks
    Behind The Success And Failure Of A Man Is A Woman
    Share on Google+

  6. #6
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    ok i got it link to access ...how do I export it to ORACLE NOW
    Behind The Success And Failure Of A Man Is A Woman
    Share on Google+

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    how many old posts are you going to dig up and keep spamming the forums?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width