FIX: IMPORT ... TYPE WK1|WR1 Truncates Column Widths to 9

ID: Q104049

2.50x 2.6 | 2.00 2.50x 2.60

WINDOWS    | MS-DOS

The information in this article applies to:

• Microsoft FoxPro for Windows, versions 2.5x, 2.6
• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5x, 2.6

SYMPTOMS

After you import a Lotus (type WK1) or Symphony (type WR1) worksheet into FoxPro, all field lengths are 9 instead of the corresponding column widths from the worksheet, which causes the data from the worksheet to be truncated.

CAUSE

The IMPORT FROM <wk1 file> TYPE WK1 or IMPORT FROM <wr1 file> TYPE WR1 command in FoxPro creates a table structure with field widths of 9.

RESOLUTION

To work around this problem, create the database structure in FoxPro and use the APPEND FROM <wk1 file> TYPE WK1 or APPEND FROM <wr1 file> TYPE WR1 command.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in FoxPro version 2.6a for Windows and FoxPro version 2.6a for MS-DOS.

Additional reference words: FoxDos FoxWin buglist2.00 buglist2.50 buglist2.50a export transfer cut off shortened buglist2.50b buglist2.60 2.00 2.50 2.50a 2.50b 2.60 KBCategory: kb3rdparty kbfixlist kbbuglist KBSubcategory: FxinteropSpread Solution Type : kbfix

Last Reviewed: September 22, 1997