Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/104049

From BetaArchive Wiki

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

ID: Q104049

2.50x 2.6 | 2.00 2.50x 2.60


kb3rdparty kbfixlist kbbuglist 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


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
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.