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--