This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
The two posts you made are to me identical. You should have posted it as one thread. Here are my two cents, which in this case is actually worth much much more than that. Get Visual Foxpro instead of Foxpro 2.6. In Visual Foxpro you will be able to create "Remote Views" which connect to Oracle threw a Connection, in this case ODBC. You can then use the Remote View as if it was a .dbf file. You will have to make the Remote View updatable, so using the wizard/view builder, is the easiest approach. Then all you have to do is use the Remote View in a work area, and use the "APPEND FROM" command in Foxpro to append from the actual Foxpro 2.6 .dbf file. Ok so that is the basics of how to convert from Foxpro to Oracle. Here are some more suggestions. 1. Create a .sql script that will create an exact duplicate version of all your .dbf files you want to convert. This way you can make a simple program that uses the remote views then appends from the Foxpro tables. You can run them as many times as you like. Then if you are trying to convert into a new data model that is designed in Oracle, you can now use standard SQL, PL/SQL commands to manipulate your data into the new model. Good Luck. I am going to close the other thread. Go Buy Foxpro 7.0 or 8.0 which ever is the latest version. Mark