BUG: FoxPro Does Not Import .DIF Format File
Article ID: 105834
Article Last Modified on 10/16/2002
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft Visual FoxPro 5.0 Standard Edition
- Microsoft Visual FoxPro 5.0a
- Microsoft Visual FoxPro 6.0 Professional Edition
- Microsoft FoxPro 2.0
- Microsoft FoxPro 2.6 for MS-DOS
- Microsoft FoxPro 2.6a Standard Edition
- Microsoft FoxPro 2.6 Standard Edition
- Microsoft FoxPro 2.6a Standard Edition
- Microsoft FoxPro 2.6a Professional Edition for Macintosh
This article was previously published under Q105834
SYMPTOMS
When attempting to append a Data Interchange Format (DIF) file, the
following error message is returned:
Invalid DIF vector - DBF field mismatch.
RESOLUTION
Perform one of the following:
- If the software that generated the .DIF file supports any of the file
types supported in FoxPro, use one of them instead. For a list of
supported file types see the APPEND FROM command in the "Microsoft
FoxPro Language Reference" L3-193. FoxPro can also open dBASE files
directly. If this is not possible, you will need to use Low-Level file
I/O; see Chapter 10 of the "Developers Guide."
-or-
- Reverse the Vector and Tuple values.
DIF files are essentially text files that contain various statements
defining the data items. Among the data in a .DIF file are items labeled
'VECTORS' and 'TUPLES'. Reverse the values for the Vectors and Tuples.
For example, here is a sample Microsoft Excel .DIF file that FoxPro
can't import:
Modify the file so that it looks like the following:
STATUS
Microsoft is researching this problem and will post new information here in
the Microsoft Knowledge Base as it becomes available.
Additional query words: DIF APPEND FROM FAR errmsg err msg xl kbvfp300 kbvfp500 kbvfp600
Keywords: kbbug kbinterop KB105834