HOWTO: How to Convert FoxPro 3.0 Tables to FoxPro 2.x Format

MORE INFORMATION

Example Workaround

1. Open an existing Visual FoxPro table
2. Issue the following command in the Command window:

         COPY TO <table name> TYPE FOX2X

Issues When Converting from 3.0 to 2.x

• Any rules, triggers, captions, comments, or default values created for the Visual FoxPro table will not be available in FoxPro 2.X
• Null values stored within the Visual FoxPro table will be converted to blank values in FoxPro 2.x. For Numeric, Float, Integer, Double and Currency data types, null values in the source table will be converted to zero.
• A Visual FoxPro field with the data type of Currency or Double will be converted to Float in FoxPro 2.X. Numeric precision may be lost for large values stored in Double fields.
• A Visual FoxPro field with the data type of DateTime will be converted to Date in FoxPro 2.x. The time portion of the DateTime field will be lost in the conversion.
• A Visual FoxPro field with the data type of Integer will be converted to Numeric in FoxPro 2.x.