Fox Pro Data Load

[Richard Mitchell <richard.mitchell@GSA.GOV>]

     To hopefully add to an earlier solution -

     You can attach the FOXPRO tables to ORACLE through Access/Attach
     Table, to eliminate the need to create multiple new tables.

     When you go through the attach table dialog you can select an ODBC
     connection (Oracle) assuming the ODBC is installed. A wizard like
     dialog will help you through but it is a little vague.

     An advantage to this approach is the availability of the latest data,
     with fewer possibilities for data conversion errors. Another advantage
     is that queries of all types can be created from the original data.
     EXAMPLE: First, define any append query as a select, adding fields and
     conditions until the result is correct. When correct, change to an
     append query (or Make Table) and put that data into the new table.

     Once the tables (new or old) are attached you can add or manually edit
     records through Access, for those situations when a query might be
     slow to develop and would only be used for a few records

     Hope this helps,

     Rick