Microsoft KB Archive/104049
FIX: IMPORT ... TYPE WK1|WR1 Truncates Column Widths to 9
2.50x 2.6 | 2.00 2.50x 2.60
WINDOWS | MS-DOS
kb3rdparty kbfixlist kbbuglist The information in this article applies to:
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.
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.
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.
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