Steve,

Quite often Excel produces file which could not be opened by VFP. Did you try to use the table?

It may create fields with the duplicate names.

>The first couple of tries, your test program did not choke on the copy
>to type delimited command. But nothing would be in the test.txt file.
>
>create cursor x1 ( i1 i, c1 c(10) )
>insert into x1 values ( 1, 'test' )
>copy to test.txt type DELIMITED
>modi file test.txt
>
>But since the copy to delim was working, I tried it with the offending table
>which happens to be called IB2005. The first time
>copy to ibAll.txt type DELIMITED
>worked. Then I tried a
>copy to test.txt type DELIMITED with ";"
>And got the error. Now, however, this brings an error at the copy to
>delim command.
>create cursor x1 ( i1 i, c1 c(10) )
>insert into x1 values ( 1, 'test' )
>copy to test.txt type DELIMITED &&invalid path or file name
>
>But if I do a copy command with a different file name, it works
>copy to est.txt type DELIMITED &&works fine
>modi file est.txt && shows the values inserted into cursor
>
>This has me confused. I thought that the copy command was supposed to
>overwrite the destination file? Is IB2005.dbf is corrupted is their a way
>to repair it. In my program, IB2005 gets created by having foxpro open up
>an excell worksheet, write it to a DBF file, which foxpro then opens and uses.
>So the table is actually created by excel. Assuming that the file from
>excel might be corrupted, I suppose I could get around that
>by having excel write as csv file and then appending that into a table created
>programmatically in foxpro.
>Steve