BUG: Import Wizard Incorrectly Treats Consecutive Delimiters
Article ID: 157724
Article Last Modified on 10/15/2003
APPLIES TO
- Microsoft Visual FoxPro 5.0 Standard Edition
- Microsoft Visual FoxPro 6.0 Professional Edition
This article was previously published under Q157724
SYMPTOMS
The Import Wizard does not properly import a file containing consecutive
delimiters. First, the Import Wizard does not treat consecutive delimiter
characters as one field. The Import Wizard creates an extra column in the
data table (.dbf). Second, the Import Wizard may truncate data that appears
in the text file. This happens with files delimited with tabs or commas.
WORKAROUND
Create a table with the desired structure. Then write a program using low-
level file functions to parse the text file and place the data into the
newly created table.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Additional query words: kbdsd VFoxWin
Keywords: kb3rdparty KB157724