Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing Data Error
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00750825
Message ID:
00750930
Vues:
13
Hi R.D.K,

IMPORT command creates a table with the same name as Excel file and extension .DBF. In your case the name of table would be PR20021219THRU20021219.DBF. In DBC it's stored under name Citgo. When you do import second or more time, the table already exist in DBC that's why VFP gives an error. You can issue DROP TABLE Citgo command before import to drop previous version of the table. Keep in mind, that adding and droping tables will cause DBC to grow.

>Is there any reason that
>
>"IMPORT FROM c:\Temp\PR20021219THRU20021219.xls DATABASE Time NAME Citgo TYPE XLS"
>
>Works fine from the command line but crashes when run inside of an app?
>
>Error message returned is
>
>"File PR20021219THRU20021219.dbf already exists as part of a database"
>
>I have tried it with the xls and without. Returns the same message. I have no idea where the extension in the error message is comming from???
>
>Bob
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform