ID: Q114639
2.60 WINDOWS
buglist2.60
The information in this article applies to:
When FoxPro is attempting to overwrite an existing .DBF file after an import, one of the following situations occurs:
-or-
-or-
The cause of this problem has not yet been determined.
To avoid this problem, check for the existence of the file before sending output to it. If the file exists, delete it.
Microsoft has confirmed this to be a problem FoxPro 2.6 for Windows. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
1. Start Catalog Manager.
2. Create a new, empty catalog.
3. From the Data menu, choose Import.
4. Import a Microsoft Excel 4.0 worksheet named TEST.XLS into the default
directory.
5. From the Data menu, choose Export, and change the type to Multiplan
4.01.
6. Set the save as directory to be the same as the default directory.
7. From the Data menu, choose Import, and change the type to Multiplan
4.01.
8. When you are asked "Overwrite dbf?", choose Yes.
9. In the Import Data dialog box, choose OK.
At this point one of the problems described above will occur.
You can also reproduce the problem by running the following code:
IMPORT FROM <drive>:\excel\qe\<filename>.xls TYPE xls
COPY TO <filename>.mod TYPE mod
USE
IMPORT FROM <filename>.mod TYPE mod
For example:
IMPORT FROM d:\excel\qe\emp.xls TYPE xls
COPY TO emp.mod TYPE mod
USE
IMPORT FROM emp.mod TYPE mod
Additional reference words: FoxWin 2.60 buglist2.60 spreadsheet target
source
KBCategory:
KBSubcategory: FxtoolCatman
Keywords : kberrmsg FxtoolCatman
Version : 2.60
Platform : WINDOWS
Last Reviewed: May 22, 1998