Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing Data Error
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00750825
Message ID:
00750930
Views:
15
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform