foxpro to oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: foxpro to oracle

  1. #1
    Join Date
    Sep 2001
    Location
    chennai
    Posts
    69
    hello friends

    i ve some foxpro tables(.dbf files) which i want to convert to oracle. i used sql loader to do this. but since in foxpro the data are seperated by tab i cannot give the position of the data exatly. how can i do it . can any one suggest me a way out.

    regards

    swamianthan

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Thumbs up


    Possibilities:

    Import the FoxPro database into an ACCESS database.
    From there you could inport into Oracle effectively.

    Access should be able to read all the .dbf files and create an appropriate DB without any problems. See if this works.

    - Magnus

  3. #3
    Join Date
    Mar 2002
    Posts
    12

    Wink

    Hello Swamianthan,

    You can use:

    fields terminated by X'09' or fields terminated by whitespace.

    Hope this helps,

    Regards,
    Noel.

  4. #4
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    whoops, I misread the original post.
    my way would be the LONG route, but you could get the tables exported from access comma-delimited.

    NEKELLY is correct.

  5. #5
    Join Date
    Jun 2001
    Posts
    132
    you can export the dbf file to a comma delimited file or you can also use Perl DBI to read the dbf files and insert them into an oracle table.
    You think I'm going to have an affair with you? --Stanley Kowalski

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